Tabel SAP B1 - DPI1 - A/R Down Payment - Rows

Oleh jurnal firman

List \ DPI1

Berikut ini adalah kolom yang terdapat pada tabel DPI1 di SAP B1

Update: 2026-07-22

No Nama Kolom Tipe Data Keterangan Referensi
1. DocEntry Integer
2. LineNum Integer
3. TargetType Integer
4. TrgetEntry Integer
5. BaseRef NVarchar (16)
6. BaseType Integer
7. BaseEntry Integer
8. BaseLine Integer
9. LineStatus NVarchar (1)
10. ItemCode NVarchar (50)
11. Dscription NVarchar (200)
12. Quantity Decimal (21, 6)
13. ShipDate Time Stamp
14. OpenQty Decimal (21, 6)
15. Price Decimal (21, 6)
16. Currency NVarchar (3)
17. Rate Decimal (21, 6)
18. DiscPrcnt Decimal (21, 6)
19. LineTotal Decimal (21, 6)
20. TotalFrgn Decimal (21, 6)
21. OpenSum Decimal (21, 6)
22. OpenSumFC Decimal (21, 6)
23. VendorNum NVarchar (50)
24. SerialNum NVarchar (17)
25. WhsCode NVarchar (8)
26. SlpCode Integer
27. Commission Decimal (21, 6)
28. TreeType NVarchar (1)
29. AcctCode NVarchar (15)
30. TaxStatus NVarchar (1)
31. GrossBuyPr Decimal (21, 6)
32. PriceBefDi Decimal (21, 6)
33. DocDate Time Stamp
34. Flags Integer
35. OpenCreQty Decimal (21, 6)
36. UseBaseUn NVarchar (1)
37. SubCatNum NVarchar (50)
38. BaseCard NVarchar (15)
39. TotalSumSy Decimal (21, 6)
40. OpenSumSys Decimal (21, 6)
41. InvntSttus NVarchar (1)
42. OcrCode NVarchar (8)
43. Project NVarchar (20)
44. CodeBars NVarchar (254)
45. VatPrcnt Decimal (21, 6)
46. VatGroup NVarchar (8)
47. PriceAfVAT Decimal (21, 6)
48. Height1 Decimal (21, 6)
49. Hght1Unit Smallint
50. Height2 Decimal (21, 6)
51. Hght2Unit Smallint
52. Width1 Decimal (21, 6)
53. Wdth1Unit Smallint
54. Width2 Decimal (21, 6)
55. Wdth2Unit Smallint
56. Length1 Decimal (21, 6)
57. Len1Unit Smallint
58. length2 Decimal (21, 6)
59. Len2Unit Smallint
60. Volume Decimal (21, 6)
61. VolUnit Smallint
62. Weight1 Decimal (21, 6)
63. Wght1Unit Smallint
64. Weight2 Decimal (21, 6)
65. Wght2Unit Smallint
66. Factor1 Decimal (21, 6)
67. Factor2 Decimal (21, 6)
68. Factor3 Decimal (21, 6)
69. Factor4 Decimal (21, 6)
70. PackQty Decimal (21, 6)
71. UpdInvntry NVarchar (1)
72. BaseDocNum Integer
73. BaseAtCard NVarchar (100)
74. SWW NVarchar (16)
75. VatSum Decimal (21, 6)
76. VatSumFrgn Decimal (21, 6)
77. VatSumSy Decimal (21, 6)
78. FinncPriod Integer
79. ObjType NVarchar (20)
80. LogInstanc Integer
81. BlockNum NVarchar (100)
82. ImportLog NVarchar (20)
83. DedVatSum Decimal (21, 6)
84. DedVatSumF Decimal (21, 6)
85. DedVatSumS Decimal (21, 6)
86. IsAqcuistn NVarchar (1)
87. DistribSum Decimal (21, 6)
88. DstrbSumFC Decimal (21, 6)
89. DstrbSumSC Decimal (21, 6)
90. GrssProfit Decimal (21, 6)
91. GrssProfSC Decimal (21, 6)
92. GrssProfFC Decimal (21, 6)
93. VisOrder Integer
94. INMPrice Decimal (21, 6)
95. PoTrgNum Integer
96. PoTrgEntry NVarchar (11)
97. DropShip NVarchar (1)
98. PoLineNum Integer
99. Address NVarchar (254)
100. TaxCode NVarchar (8)
101. TaxType NVarchar (1)
102. OrigItem NVarchar (50)
103. BackOrdr NVarchar (1)
104. FreeTxt NVarchar (100)
105. PickStatus NVarchar (1)
106. PickOty Decimal (21, 6)
107. PickIdNo Integer
108. TrnsCode Smallint
109. VatAppld Decimal (21, 6)
110. VatAppldFC Decimal (21, 6)
111. VatAppldSC Decimal (21, 6)
112. BaseQty Decimal (21, 6)
113. BaseOpnQty Decimal (21, 6)
114. VatDscntPr Decimal (21, 6)
115. WtLiable NVarchar (1)
116. DeferrTax NVarchar (1)
117. EquVatPer Decimal (21, 6)
118. EquVatSum Decimal (21, 6)
119. EquVatSumF Decimal (21, 6)
120. EquVatSumS Decimal (21, 6)
121. LineVat Decimal (21, 6)
122. LineVatlF Decimal (21, 6)
123. LineVatS Decimal (21, 6)
124. unitMsr NVarchar (100)
125. NumPerMsr Decimal (21, 6)
126. CEECFlag NVarchar (1)
127. ToStock Decimal (21, 6)
128. ToDiff Decimal (21, 6)
129. ExciseAmt Decimal (21, 6)
130. TaxPerUnit Decimal (21, 6)
131. TotInclTax Decimal (21, 6)
132. CountryOrg NVarchar (3)
133. StckDstSum Decimal (21, 6)
134. ReleasQtty Decimal (21, 6)
135. LineType NVarchar (1)
136. TranType NVarchar (1)
137. Text NClob
138. OwnerCode Integer
139. StockPrice Decimal (21, 6)
140. ConsumeFCT NVarchar (1)
141. LstByDsSum Decimal (21, 6)
142. StckINMPr Decimal (21, 6)
143. LstBINMPr Decimal (21, 6)
144. StckDstFc Decimal (21, 6)
145. StckDstSc Decimal (21, 6)
146. LstByDsFc Decimal (21, 6)
147. LstByDsSc Decimal (21, 6)
148. StockSum Decimal (21, 6)
149. StockSumFc Decimal (21, 6)
150. StockSumSc Decimal (21, 6)
151. StckSumApp Decimal (21, 6)
152. StckAppFc Decimal (21, 6)
153. StckAppSc Decimal (21, 6)
154. ShipToCode NVarchar (50)
155. ShipToDesc NVarchar (254)
156. StckAppD Decimal (21, 6)
157. StckAppDFC Decimal (21, 6)
158. StckAppDSC Decimal (21, 6)
159. BasePrice NVarchar (1)
160. GTotal Decimal (21, 6)
161. GTotalFC Decimal (21, 6)
162. GTotalSC Decimal (21, 6)
163. DistribExp NVarchar (1)
164. DescOW NVarchar (1)
165. DetailsOW NVarchar (1)
166. GrossBase Smallint
167. VatWoDpm Decimal (21, 6)
168. VatWoDpmFc Decimal (21, 6)
169. VatWoDpmSc Decimal (21, 6)
170. CFOPCode NVarchar (6)
171. CSTCode NVarchar (6)
172. Usage Integer
173. TaxOnly NVarchar (1)
174. WtCalced NVarchar (1)
175. QtyToShip Decimal (21, 6)
176. DelivrdQty Decimal (21, 6)
177. OrderedQty Decimal (21, 6)
178. CogsOcrCod NVarchar (8)
179. CiOppLineN Integer
180. CogsAcct NVarchar (15)
181. ChgAsmBoMW NVarchar (1)
182. ActDelDate Time Stamp
183. OcrCode2 NVarchar (8)
184. OcrCode3 NVarchar (8)
185. OcrCode4 NVarchar (8)
186. OcrCode5 NVarchar (8)
187. TaxDistSum Decimal (21, 6)
188. TaxDistSFC Decimal (21, 6)
189. TaxDistSSC Decimal (21, 6)
190. PostTax NVarchar (1)
191. Excisable NVarchar (1)
192. AssblValue Decimal (21, 6)
193. RG23APart1 Integer
194. RG23APart2 Integer
195. RG23CPart1 Integer
196. RG23CPart2 Integer
197. CogsOcrCo2 NVarchar (8)
198. CogsOcrCo3 NVarchar (8)
199. CogsOcrCo4 NVarchar (8)
200. CogsOcrCo5 NVarchar (8)
201. LnExcised NVarchar (1)
202. LocCode Integer
203. StockValue Decimal (21, 6)
204. GPTtlBasPr Decimal (21, 6)
205. unitMsr2 NVarchar (100)
206. NumPerMsr2 Decimal (21, 6)
207. SpecPrice NVarchar (1)
208. CSTfIPI NVarchar (2)
209. CSTfPIS NVarchar (2)
210. CSTfCOFINS NVarchar (2)
211. ExLineNo NVarchar (10)
212. isSrvCall NVarchar (1)
213. PQTReqQty Decimal (21, 6)
214. PQTReqDate Time Stamp
215. PcDocType Integer
216. PcQuantity Decimal (21, 6)
217. LinManClsd NVarchar (1)
218. VatGrpSrc NVarchar (1)
219. NoInvtryMv NVarchar (1)
220. ActBaseEnt Integer
221. ActBaseLn Integer
222. ActBaseNum Integer
223. OpenRtnQty Decimal (21, 6)
224. AgrNo Integer
225. AgrLnNum Integer
226. CredOrigin NVarchar (1)
227. Surpluses Decimal (21, 6)
228. DefBreak Decimal (21, 6)
229. Shortages Decimal (21, 6)
230. UomEntry Integer
231. UomEntry2 Integer
232. UomCode NVarchar (20)
233. UomCode2 NVarchar (20)
234. FromWhsCod NVarchar (8)
235. NeedQty NVarchar (1)
236. PartRetire NVarchar (1)
237. RetireQty Decimal (21, 6)
238. RetireAPC Decimal (21, 6)
239. RetirAPCFC Decimal (21, 6)
240. RetirAPCSC Decimal (21, 6)
241. InvQty Decimal (21, 6)
242. OpenInvQty Decimal (21, 6)
243. EnSetCost NVarchar (1)
244. RetCost Decimal (21, 6)
245. Incoterms Integer
246. TransMod Integer
247. LineVendor NVarchar (15)
248. DistribIS NVarchar (1)
249. ISDistrb Decimal (21, 6)
250. ISDistrbFC Decimal (21, 6)
251. ISDistrbSC Decimal (21, 6)
252. IsByPrdct NVarchar (1)
253. ItemType Integer
254. PriceEdit NVarchar (1)
255. PrntLnNum Integer
256. LinePoPrss NVarchar (1)
257. FreeChrgBP NVarchar (1)
258. TaxRelev NVarchar (1)
259. LegalText NVarchar (254)
260. ThirdParty NVarchar (1)
261. LicTradNum NVarchar (32)
262. InvQtyOnly NVarchar (1)
263. UnencReasn Integer
264. ShipFromCo NVarchar (50)
265. ShipFromDe NVarchar (254)
266. FisrtBin NVarchar (228)
267. AllocBinC NVarchar (11)
268. ExpType NVarchar (4)
269. ExpUUID NVarchar (50)
270. ExpOpType NVarchar (1)
271. DIOTNat NVarchar (3)
272. MYFtype NVarchar (2)
273. GPBefDisc Decimal (21, 6)
274. ReturnRsn Smallint
275. ReturnAct Smallint
276. StgSeqNum Integer
277. StgEntry Integer
278. StgDesc NVarchar (100)
279. ItmTaxType NVarchar (2)
280. SacEntry Integer
281. NCMCode Integer
282. HsnEntry Integer
283. OriBAbsEnt Integer
284. OriBLinNum Integer
285. OriBDocTyp Integer
286. IsPrscGood NVarchar (1)
287. IsCstmAct NVarchar (1)
288. EncryptIV NVarchar (100)
289. ExtTaxRate Decimal (21, 6)
290. ExtTaxSum Decimal (21, 6)
291. TaxAmtSrc NVarchar (1)
292. ExtTaxSumF Decimal (21, 6)
293. ExtTaxSumS Decimal (21, 6)
294. StdItemId Integer
295. CommClass Integer
296. VatExEntry Integer
297. VatExLN Smallint
298. NatOfTrans Integer
299. ISDtCryImp NVarchar (3)
300. ISDtRgnImp Integer
301. ISOrCryExp NVarchar (3)
302. ISOrRgnExp Integer
303. NVECode NVarchar (6)
304. PoNum NVarchar (20)
305. PoItmNum Integer
306. IndEscala NVarchar (1)
307. CESTCode Integer
308. CtrSealQty Decimal (21, 6)
309. CNJPMan NVarchar (14)
310. UFFiscBene NVarchar (10)
311. CUSplit NVarchar (1)
312. LegalTIMD NVarchar (250)
313. LegalTTCA NVarchar (250)
314. LegalTW NVarchar (250)
315. LegalTCD NVarchar (250)
316. RevCharge NVarchar (1)
317. ListNum Smallint
318. U_SOL_QTY_KOLI Decimal (21, 6)
319. U_SOL_QTY_PER_KOLI Decimal (21, 6)
320. U_SOL_DISCOUNT1 Decimal (21, 6)
321. U_SOL_DISCOUNT2 Decimal (21, 6)
322. U_SOL_DISCOUNT3 Decimal (21, 6)
323. U_SOL_DOWNTIME Decimal (21, 6)
324. U_SOL_DURASI Decimal (21, 6)
325. U_SOL_PRICE_LIST_POS NVarchar (30)
326. U_SOL_REMARKS NClob
327. U_SOL_QTY_FISIK Decimal (21, 6)
328. U_SOL_PRICE_LIST NVarchar (40)
329. U_SOL_NO_FAKTUR NVarchar (20)
330. U_SOL_TGL_FAKTUR Time Stamp
331. U_SOL_PRICE_ECOMMERCE Decimal (21, 6)
332. U_SOL_OUTER Decimal (21, 6)
333. U_SOL_BPROD Decimal (21, 6)
334. U_HR_NO_PO NVarchar (10)
335. U_HR_NO_SJ NVarchar (10)
336. U_HR_SITE NVarchar (10)
337. U_HR_REMARK NVarchar (20)
338. U_AA_BASEENTRY NVarchar (30)
339. U_AA_BASELINE NVarchar (30)
340. U_AA_BASETYPE NVarchar (30)
341. U_AA_PROCID NVarchar (30)
342. U_HR_UoM_SERVICE NVarchar (10)
343. U_HR_NO_RETUR NVarchar (10)
344. U_ORIGINAL_PRICE Decimal (21, 6)
345. U_AA_KET_CEK NVarchar (250)
346. U_HR_Location NVarchar (30)
347. U_HR_Employee NVarchar (30)
348. U_HR_StsPrice NVarchar (30)
349. U_HR_RmkOvr NVarchar (50)
350. U_HR_TTL_CBM NVarchar (10)
351. U_HR_Segmen NVarchar (50)

Postingan populer dari blog ini

SMS Penipuan PT Centrall Cell

Oleh jurnal firman
Sebelum anda melanjutkan membaca artikel ini, hentikan segala aktifitas transfer yang akan anda lakukan setelah menerima SMS adanya penawaran agen pulsa dengan harga 4500, 8500 dan sejenisnya. Saya semalam mendapatkan SMS yang mengatasnamakan PT. CENTRAL CELL, dimana isi SMSnya adalah berupa penawaran agen pulsa elektrik dengan harga yang boleh dibilang, terlalu miring. Berikut ini detail SMS yang dikirim menggunakan Nomer 081998377179. "KAMI DARI PT.CENTRAL CELL Cari agen M.KIOS all operator V.5=4500 V.10=8500 V.20=18500 CARA PENDAFTARAN ketik: DAFTAR.NAMA.KOTA.NO HP# Kirim ke: 085341122822" Meski saya gak mudah percaya, tapi jujur saja, iklan tersebut cukup menarik minat saya. Apalagi saya juga pengusaha server pulsa elektrik , yang sekali lagi jujur saja, saya pun gak dapat harga segitu.
Read more »

Apa itu "Pejwan"

Oleh jurnal firman
Sering kali kita mendapati istilah "Pertamax" dan "Pejwan" dalam forum-forum diskusi ataupun komentar-komentar di sebuah blog. Untuk Pertamax istilah itu sekarang sudah cukup umum, yang artinya adalah seorang komentator yang mendapati peringkat pertama sebagai orang yang memberikan komentar pada konten yang bersangkutan. Sedangkan Pejwan tidak lain adalah "Page One", yaitu posisi komentar kita pada halaman pertama dari suatu konten yang kita komentari. Jadi, meskipun tidak mendapatkan Pertamax, Pejwan pun gak masalah, karena masih memiliki kemungkinan besar untuk memberikan pengaruh dalam mendatangkan pengunjung ke blog kita. Terima kasih untuk yang sudah mensupport halaman ini: infosia.my.id blog jitu inisurabaya.id halaqoh.id always.my.id
Read more »