Tabel SAP B1 - OIGE - Goods Issue

List \ OIGE

Berikut ini adalah kolom yang terdapat pada tabel OIGE 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)
449. U_SOL_TIPE_ORDER NVarchar (50)
450. U_SOL_EKSPEDISI NVarchar (50)
451. U_SOL_KEMBALI Decimal (21, 6)
452. U_SOL_NAMA_CHECKER NVarchar (30)
453. U_SOL_NAMA_KASIR NVarchar (50)
454. U_SOL_NO_MOBIL NVarchar (50)
455. U_SOL_PENGAJUAN_BAYAR NVarchar (30)
456. U_SOL_NO_RESI NVarchar (30)
457. U_SOL_NAMA_CONS NVarchar (30)
458. U_SOL_COMODITY NVarchar (30)
459. U_SOL_CONTAINER NVarchar (30)
460. U_SOL_QTY_PARTY Decimal (21, 6)
461. U_SOL_EKSPEDISI_REASON NVarchar (50)
462. U_SOL_DOF Time Stamp
463. U_SOL_ARRIVAL_DATE Time Stamp
464. U_SOL_NO_PPJK NVarchar (30)
465. U_SOL_PELAYARAN NVarchar (30)
466. U_SOL_POD NVarchar (30)
467. U_SOL_VESSEL NVarchar (30)
468. U_SOL_NO_PIB_PEB NVarchar (30)
469. U_SOL_NOPEN NVarchar (30)
470. U_SOL_NOPEN_TANGGAL Time Stamp
471. U_SOL_PENJALURAN NVarchar (30)
472. U_SOL_ECOMMERCE NVarchar (50)
473. U_SOL_TGL_SPPB Time Stamp
474. U_SOL_TGL_TAGIHAN Time Stamp
475. U_SOL_GUD_TERIMA NVarchar (100)
476. U_SOL_FREK_PENAGIHAN NVarchar (30)
477. U_SOL_NAMA_PIC NVarchar (30)
478. U_SOL_TGL_PIC_CONFIRM Time Stamp
479. U_SOL_ALASAN_RETURN NVarchar (30)
480. U_SOL_TIPE_BAYAR NVarchar (30)
481. U_SOL_NOMINAL_BAYAR Decimal (21, 6)
482. U_SOL_RAYON1 NVarchar (50)
483. U_SOL_PROVINSI NVarchar (50)
484. U_SOL_KT_KBPT NVarchar (50)
485. U_SOL_KOTA NVarchar (50)
486. U_SOL_BANK NVarchar (30)
487. U_SOL_TIPE_PO NVarchar (50)
488. U_SOL_TIPE_TRANSFER NVarchar (50)
489. U_SOL_TIPE_RECEIPT NVarchar (50)
490. U_SOL_TIPE_ISSUE NVarchar (50)
491. U_SOL_FP_BRANCH NVarchar (20)
492. U_SOL_FP_TRX_CODE NVarchar (2)
493. U_SOL_FP_STATUS_CODE NVarchar (1)
494. U_SOL_FP_RUNNING_NO NVarchar (20)
495. U_SOL_FP_FULL_NO NVarchar (19)
496. U_SOL_FP_PPN NVarchar (2)
497. U_SOL_KMK NVarchar (20)
498. U_SOL_PPN_DATE Time Stamp
499. U_SOL_EXPORTED NVarchar (5)
500. U_SOL_NO_AR_TOKO NVarchar (10)
501. U_SOL_SIZE_TYPE NVarchar (20)
502. U_SOL_PAJAK NVarchar (1)
503. U_SOL_STAT_COMODITY NVarchar (1)
504. U_SOL_PROJECT NVarchar (40)
505. U_SOL_ALAMAT_EX NVarchar (254)
506. U_SOL_RUTE_EX NVarchar (10)
507. U_SOL_BANK2 NVarchar (15)
508. U_SOL_SALES_TAGIH NVarchar (30)
509. U_NDY_NO_PO NVarchar (15)
510. U_NDY_TIPE_RETURN NVarchar (30)
511. U_BARCODE_USER NVarchar (30)
512. U_BARCODE_DT NVarchar (50)
513. U_BASE_GRPO NVarchar (30)
514. U_QC_CONFIRMATION NVarchar (1)
515. U_PRICE_CONFIRMATION NVarchar (1)
516. U_HR_SITE NVarchar (10)
517. U_DELIVERED_TIME Time Stamp
518. U_AA_TSTS NVarchar (3)
519. U_AA_TAPR NVarchar (1)
520. U_AA_TAPRID NVarchar (30)
521. U_AA_TNO NVarchar (254)
522. U_AA_TSEQ NVarchar (30)
523. U_AA_TTYPE NVarchar (50)
524. U_AA_HCEP_NO NVarchar (20)
525. U_APPROVAL_TOKEN NVarchar (10)
526. U_EMAILED NVarchar (1)
527. U_HR_DEPARTMENT NVarchar (40)
528. U_AA_TUSER NVarchar (30)
529. U_HR_RMK_PERDIN NVarchar (100)
530. U_SUPERVISOR_APPROVAL NVarchar (1)
531. U_HR_SUB_LOC NVarchar (50)
532. U_BARCODE_NAME NVarchar (100)
533. U_APPROVAL_CRM NVarchar (50)
534. U_SIGNATURE_STATUS NVarchar (1)
535. U_SUPERVISOR_REMARKS NClob
536. U_FK_REKENING_MANUAL NVarchar (30)
537. U_HR_TOKEN NVarchar (10)
538. U_HR_DIVISI NVarchar (40)
539. U_RECEIVED Time Stamp
540. U_SOL_DOF_2 Time Stamp
541. U_SOL_NO_RESI_2 NVarchar (30)
542. U_SOL_TIPE_VENDOR NVarchar (10)
543. U_AAP_TIPE_BAYAR NVarchar (50)
544. U_AAP_WHY_NOMINAL_TIPE Integer
545. U_AAP_TIPE_BAYAR_SISA NVarchar (50)
546. U_DYA_APPROVE_PCH NVarchar (10)
547. U_DYA_PROJECT_MANUAL NVarchar (20)
548. U_SOL_JML_KOLI Decimal (21, 6)
549. U_INV NVarchar (1)
550. U_FCACHED Integer
551. U_DCACHED Time Stamp
552. U_TCACHED Integer
553. U_CREATE_USER NVarchar (10)
554. U_UPDATE_USER NVarchar (10)

Postingan populer dari blog ini

SMS Penipuan PT Centrall Cell

Apa itu "Pejwan"