Tabel SAP B1 - OPCH - A/P Invoice

Oleh jurnal firman

List \ OPCH

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

Update: 2026-07-23

No Nama Kolom Tipe Data Keterangan Referensi
1. DocEntry Integer
2. DocNum Integer
3. DocType NVarchar (1)
4. CANCELED NVarchar (1)
5. Handwrtten NVarchar (1)
6. Printed NVarchar (1)
7. DocStatus NVarchar (1)
8. InvntSttus NVarchar (1)
9. Transfered NVarchar (1)
10. ObjType NVarchar (20)
11. DocDate Time Stamp
12. DocDueDate Time Stamp
13. CardCode NVarchar (15)
14. CardName NVarchar (100)
15. Address NVarchar (254)
16. NumAtCard NVarchar (100)
17. VatPercent Decimal (21, 6)
18. VatSum Decimal (21, 6)
19. VatSumFC Decimal (21, 6)
20. DiscPrcnt Decimal (21, 6)
21. DiscSum Decimal (21, 6)
22. DiscSumFC Decimal (21, 6)
23. DocCur NVarchar (3)
24. DocRate Decimal (21, 6)
25. DocTotal Decimal (21, 6)
26. DocTotalFC Decimal (21, 6)
27. PaidToDate Decimal (21, 6)
28. PaidFC Decimal (21, 6)
29. GrosProfit Decimal (21, 6)
30. GrosProfFC Decimal (21, 6)
31. Ref1 NVarchar (11)
32. Ref2 NVarchar (11)
33. Comments NVarchar (254)
34. JrnlMemo NVarchar (254)
35. TransId Integer
36. ReceiptNum Integer
37. GroupNum Smallint
38. DocTime Smallint
39. SlpCode Integer
40. TrnspCode Smallint
41. PartSupply NVarchar (1)
42. Confirmed NVarchar (1)
43. GrossBase Smallint
44. ImportEnt Integer
45. CreateTran NVarchar (1)
46. SummryType NVarchar (1)
47. UpdInvnt NVarchar (1)
48. UpdCardBal NVarchar (1)
49. Instance Smallint
50. Flags Integer
51. InvntDirec NVarchar (1)
52. CntctCode Integer
53. ShowSCN NVarchar (1)
54. FatherCard NVarchar (15)
55. SysRate Decimal (21, 6)
56. CurSource NVarchar (1)
57. VatSumSy Decimal (21, 6)
58. DiscSumSy Decimal (21, 6)
59. DocTotalSy Decimal (21, 6)
60. PaidSys Decimal (21, 6)
61. FatherType NVarchar (1)
62. GrosProfSy Decimal (21, 6)
63. UpdateDate Time Stamp
64. IsICT NVarchar (1)
65. CreateDate Time Stamp
66. Volume Decimal (21, 6)
67. VolUnit Smallint
68. Weight Decimal (21, 6)
69. WeightUnit Smallint
70. Series Integer
71. TaxDate Time Stamp
72. Filler NVarchar (8)
73. DataSource NVarchar (1)
74. StampNum NVarchar (16)
75. isCrin NVarchar (1)
76. FinncPriod Integer
77. UserSign Smallint
78. selfInv NVarchar (1)
79. VatPaid Decimal (21, 6)
80. VatPaidFC Decimal (21, 6)
81. VatPaidSys Decimal (21, 6)
82. UserSign2 Smallint
83. WddStatus NVarchar (1)
84. draftKey Integer
85. TotalExpns Decimal (21, 6)
86. TotalExpFC Decimal (21, 6)
87. TotalExpSC Decimal (21, 6)
88. DunnLevel Integer
89. Address2 NVarchar (254)
90. LogInstanc Integer
91. Exported NVarchar (1)
92. StationID Integer
93. Indicator NVarchar (2)
94. NetProc NVarchar (1)
95. AqcsTax Decimal (21, 6)
96. AqcsTaxFC Decimal (21, 6)
97. AqcsTaxSC Decimal (21, 6)
98. CashDiscPr Decimal (21, 6)
99. CashDiscnt Decimal (21, 6)
100. CashDiscFC Decimal (21, 6)
101. CashDiscSC Decimal (21, 6)
102. ShipToCode NVarchar (50)
103. LicTradNum NVarchar (32)
104. PaymentRef NVarchar (27)
105. WTSum Decimal (21, 6)
106. WTSumFC Decimal (21, 6)
107. WTSumSC Decimal (21, 6)
108. RoundDif Decimal (21, 6)
109. RoundDifFC Decimal (21, 6)
110. RoundDifSy Decimal (21, 6)
111. CheckDigit NVarchar (1)
112. Form1099 Integer
113. Box1099 NVarchar (20)
114. submitted NVarchar (1)
115. PoPrss NVarchar (1)
116. Rounding NVarchar (1)
117. RevisionPo NVarchar (1)
118. Segment Smallint
119. ReqDate Time Stamp
120. CancelDate Time Stamp
121. PickStatus NVarchar (1)
122. Pick NVarchar (1)
123. BlockDunn NVarchar (1)
124. PeyMethod NVarchar (15)
125. PayBlock NVarchar (1)
126. PayBlckRef Integer
127. MaxDscn NVarchar (1)
128. Reserve NVarchar (1)
129. Max1099 Decimal (21, 6)
130. CntrlBnk NVarchar (15)
131. PickRmrk NVarchar (254)
132. ISRCodLine NVarchar (53)
133. ExpAppl Decimal (21, 6)
134. ExpApplFC Decimal (21, 6)
135. ExpApplSC Decimal (21, 6)
136. Project NVarchar (20)
137. DeferrTax NVarchar (1)
138. LetterNum NVarchar (50)
139. FromDate Time Stamp
140. ToDate Time Stamp
141. WTApplied Decimal (21, 6)
142. WTAppliedF Decimal (21, 6)
143. BoeReserev NVarchar (1)
144. AgentCode NVarchar (32)
145. WTAppliedS Decimal (21, 6)
146. EquVatSum Decimal (21, 6)
147. EquVatSumF Decimal (21, 6)
148. EquVatSumS Decimal (21, 6)
149. Installmnt Smallint
150. VATFirst NVarchar (1)
151. NnSbAmnt Decimal (21, 6)
152. NnSbAmntSC Decimal (21, 6)
153. NbSbAmntFC Decimal (21, 6)
154. ExepAmnt Decimal (21, 6)
155. ExepAmntSC Decimal (21, 6)
156. ExepAmntFC Decimal (21, 6)
157. VatDate Time Stamp
158. CorrExt NVarchar (25)
159. CorrInv Integer
160. NCorrInv Integer
161. CEECFlag NVarchar (1)
162. BaseAmnt Decimal (21, 6)
163. BaseAmntSC Decimal (21, 6)
164. BaseAmntFC Decimal (21, 6)
165. CtlAccount NVarchar (15)
166. BPLId Integer
167. BPLName NVarchar (100)
168. VATRegNum NVarchar (32)
169. TxInvRptNo NVarchar (10)
170. TxInvRptDt Time Stamp
171. KVVATCode NClob
172. WTDetails NVarchar (100)
173. SumAbsId Integer
174. SumRptDate Time Stamp
175. PIndicator NVarchar (10)
176. ManualNum NVarchar (20)
177. UseShpdGd NVarchar (1)
178. BaseVtAt Decimal (21, 6)
179. BaseVtAtSC Decimal (21, 6)
180. BaseVtAtFC Decimal (21, 6)
181. NnSbVAt Decimal (21, 6)
182. NnSbVAtSC Decimal (21, 6)
183. NbSbVAtFC Decimal (21, 6)
184. ExptVAt Decimal (21, 6)
185. ExptVAtSC Decimal (21, 6)
186. ExptVAtFC Decimal (21, 6)
187. LYPmtAt Decimal (21, 6)
188. LYPmtAtSC Decimal (21, 6)
189. LYPmtAtFC Decimal (21, 6)
190. ExpAnSum Decimal (21, 6)
191. ExpAnSys Decimal (21, 6)
192. ExpAnFrgn Decimal (21, 6)
193. DocSubType NVarchar (2)
194. DpmStatus NVarchar (1)
195. DpmAmnt Decimal (21, 6)
196. DpmAmntSC Decimal (21, 6)
197. DpmAmntFC Decimal (21, 6)
198. DpmDrawn NVarchar (1)
199. DpmPrcnt Decimal (21, 6)
200. PaidSum Decimal (21, 6)
201. PaidSumFc Decimal (21, 6)
202. PaidSumSc Decimal (21, 6)
203. FolioPref NVarchar (4)
204. FolioNum Integer
205. DpmAppl Decimal (21, 6)
206. DpmApplFc Decimal (21, 6)
207. DpmApplSc Decimal (21, 6)
208. LPgFolioN Integer
209. Header NClob
210. Footer NClob
211. Posted NVarchar (1)
212. OwnerCode Integer
213. BPChCode NVarchar (15)
214. BPChCntc Integer
215. PayToCode NVarchar (50)
216. IsPaytoBnk NVarchar (1)
217. BnkCntry NVarchar (3)
218. BankCode NVarchar (30)
219. BnkAccount NVarchar (50)
220. BnkBranch NVarchar (50)
221. isIns NVarchar (1)
222. TrackNo NVarchar (30)
223. VersionNum NVarchar (13)
224. LangCode Integer
225. BPNameOW NVarchar (1)
226. BillToOW NVarchar (1)
227. ShipToOW NVarchar (1)
228. RetInvoice NVarchar (1)
229. ClsDate Time Stamp
230. MInvNum Integer
231. MInvDate Time Stamp
232. SeqCode Smallint
233. Serial Integer
234. SeriesStr NVarchar (3)
235. SubStr NVarchar (3)
236. Model NVarchar (6)
237. TaxOnExp Decimal (21, 6)
238. TaxOnExpFc Decimal (21, 6)
239. TaxOnExpSc Decimal (21, 6)
240. TaxOnExAp Decimal (21, 6)
241. TaxOnExApF Decimal (21, 6)
242. TaxOnExApS Decimal (21, 6)
243. LastPmnTyp NVarchar (1)
244. LndCstNum Integer
245. UseCorrVat NVarchar (1)
246. BlkCredMmo NVarchar (1)
247. OpenForLaC NVarchar (1)
248. Excised NVarchar (1)
249. ExcRefDate Time Stamp
250. ExcRmvTime NVarchar (8)
251. SrvGpPrcnt Decimal (21, 6)
252. DepositNum Integer
253. CertNum NVarchar (31)
254. DutyStatus NVarchar (1)
255. AutoCrtFlw NVarchar (1)
256. FlwRefDate Time Stamp
257. FlwRefNum NVarchar (100)
258. VatJENum Integer
259. DpmVat Decimal (21, 6)
260. DpmVatFc Decimal (21, 6)
261. DpmVatSc Decimal (21, 6)
262. DpmAppVat Decimal (21, 6)
263. DpmAppVatF Decimal (21, 6)
264. DpmAppVatS Decimal (21, 6)
265. InsurOp347 NVarchar (1)
266. IgnRelDoc NVarchar (1)
267. BuildDesc NVarchar (50)
268. ResidenNum NVarchar (1)
269. Checker Integer
270. Payee Integer
271. CopyNumber Integer
272. SSIExmpt NVarchar (1)
273. PQTGrpSer Integer
274. PQTGrpNum Integer
275. PQTGrpHW NVarchar (1)
276. ReopOriDoc NVarchar (1)
277. ReopManCls NVarchar (1)
278. DocManClsd NVarchar (1)
279. ClosingOpt Smallint
280. SpecDate Time Stamp
281. Ordered NVarchar (1)
282. NTSApprov NVarchar (1)
283. NTSWebSite Smallint
284. NTSeTaxNo NVarchar (50)
285. NTSApprNo NVarchar (50)
286. PayDuMonth NVarchar (1)
287. ExtraMonth Smallint
288. ExtraDays Smallint
289. CdcOffset Smallint
290. SignMsg NClob
291. SignDigest NClob
292. CertifNum NVarchar (50)
293. KeyVersion Integer
294. EDocGenTyp NVarchar (1)
295. ESeries Smallint
296. EDocNum NVarchar (50)
297. EDocExpFrm Integer
298. OnlineQuo NVarchar (1)
299. POSEqNum NVarchar (20)
300. POSManufSN NVarchar (20)
301. POSCashN Integer
302. EDocStatus NVarchar (1)
303. EDocCntnt NClob
304. EDocProces NVarchar (1)
305. EDocErrCod NVarchar (50)
306. EDocErrMsg NClob
307. EDocCancel NVarchar (1)
308. EDocTest NVarchar (1)
309. EDocPrefix NVarchar (10)
310. CUP Integer
311. CIG Integer
312. DpmAsDscnt NVarchar (1)
313. Attachment NClob
314. AtcEntry Integer
315. SupplCode NVarchar (254)
316. GTSRlvnt NVarchar (1)
317. BaseDisc Decimal (21, 6)
318. BaseDiscSc Decimal (21, 6)
319. BaseDiscFc Decimal (21, 6)
320. BaseDiscPr Decimal (21, 6)
321. CreateTS Integer
322. UpdateTS Integer
323. SrvTaxRule NVarchar (1)
324. AnnInvDecR Integer
325. Supplier NVarchar (15)
326. Releaser Integer
327. Receiver Integer
328. ToWhsCode NVarchar (8)
329. AssetDate Time Stamp
330. Requester NVarchar (25)
331. ReqName NVarchar (155)
332. Branch Smallint
333. Department Smallint
334. Email NVarchar (100)
335. Notify NVarchar (1)
336. ReqType Integer
337. OriginType NVarchar (1)
338. IsReuseNum NVarchar (1)
339. IsReuseNFN NVarchar (1)
340. DocDlvry NVarchar (1)
341. PaidDpm Decimal (21, 6)
342. PaidDpmF Decimal (21, 6)
343. PaidDpmS Decimal (21, 6)
344. EnvTypeNFe Integer
345. AgrNo Integer
346. IsAlt NVarchar (1)
347. AltBaseTyp Integer
348. AltBaseEnt Integer
349. AuthCode NVarchar (250)
350. StDlvDate Time Stamp
351. StDlvTime Integer
352. EndDlvDate Time Stamp
353. EndDlvTime Integer
354. VclPlate NVarchar (20)
355. ElCoStatus NVarchar (10)
356. AtDocType NVarchar (2)
357. ElCoMsg NVarchar (254)
358. PrintSEPA NVarchar (1)
359. FreeChrg Decimal (21, 6)
360. FreeChrgFC Decimal (21, 6)
361. FreeChrgSC Decimal (21, 6)
362. NfeValue Decimal (21, 6)
363. FiscDocNum NVarchar (100)
364. RelatedTyp Integer
365. RelatedEnt Integer
366. CCDEntry Integer
367. NfePrntFo Integer
368. ZrdAbs Integer
369. POSRcptNo Integer
370. FoCTax Decimal (21, 6)
371. FoCTaxFC Decimal (21, 6)
372. FoCTaxSC Decimal (21, 6)
373. TpCusPres Integer
374. ExcDocDate Time Stamp
375. FoCFrght Decimal (21, 6)
376. FoCFrghtFC Decimal (21, 6)
377. FoCFrghtSC Decimal (21, 6)
378. InterimTyp Smallint
379. PTICode NVarchar (5)
380. Letter NVarchar (1)
381. FolNumFrom Integer
382. FolNumTo Integer
383. FolSeries Integer
384. SplitTax Decimal (21, 6)
385. SplitTaxFC Decimal (21, 6)
386. SplitTaxSC Decimal (21, 6)
387. ToBinCode NVarchar (228)
388. PriceMode NVarchar (1)
389. PoDropPrss NVarchar (1)
390. PermitNo NVarchar (20)
391. MYFtype NVarchar (2)
392. DocTaxID NVarchar (32)
393. DateReport Time Stamp
394. RepSection NVarchar (3)
395. ExclTaxRep NVarchar (1)
396. PosCashReg Integer
397. DmpTransID NVarchar (20)
398. ECommerBP NVarchar (15)
399. EComerGSTN NVarchar (15)
400. Revision NVarchar (1)
401. RevRefNo NVarchar (100)
402. RevRefDate Time Stamp
403. RevCreRefN NVarchar (100)
404. RevCreRefD Time Stamp
405. TaxInvNo NVarchar (100)
406. FrmBpDate Time Stamp
407. GSTTranTyp NVarchar (2)
408. BaseType Integer
409. BaseEntry Integer
410. ComTrade NVarchar (1)
411. UseBilAddr NVarchar (1)
412. IssReason Smallint
413. ComTradeRt NVarchar (1)
414. SplitPmnt NVarchar (1)
415. SOIWizId Integer
416. SelfPosted NVarchar (1)
417. EnBnkAcct NClob
418. EncryptIV NVarchar (100)
419. DPPStatus NVarchar (1)
420. SAPPassprt NClob
421. EWBGenType NVarchar (1)
422. CtActTax Decimal (21, 6)
423. CtActTaxFC Decimal (21, 6)
424. CtActTaxSC Decimal (21, 6)
425. EDocType NVarchar (1)
426. QRCodeSrc NClob
427. AggregDoc NVarchar (1)
428. DataVers Integer
429. ShipState NVarchar (3)
430. ShipPlace NVarchar (60)
431. CustOffice NVarchar (60)
432. FCI NVarchar (36)
433. NnSbCuAmnt Decimal (21, 6)
434. NnSbCuSC Decimal (21, 6)
435. NnSbCuFC Decimal (21, 6)
436. ExepCuAmnt Decimal (21, 6)
437. ExepCuSC Decimal (21, 6)
438. ExepCuFC Decimal (21, 6)
439. AddLegIn NVarchar (100)
440. LegTextF Integer
441. IndFinal NVarchar (1)
442. DANFELgTxt NClob
443. PostPmntWT NVarchar (1)
444. QRCodeSPGn NClob
445. FCEPmnMean NVarchar (1)
446. ReqCode NVarchar (50)
447. NotRel4MI NVarchar (1)
448. Rel4PPTax NVarchar (1)

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 »