Tabel SAP B1 - OIVL - Whse Journal
List \ OIVL
Berikut ini adalah kolom yang terdapat pada tabel OIVL di SAP B1
Update: 2026-07-24
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | TransType | Integer | ||
| 2. | CreatedBy | Integer | ||
| 3. | BASE_REF | NVarchar (11) | ||
| 4. | DocLineNum | Integer | ||
| 5. | DocDate | Time Stamp | ||
| 6. | CreateTime | Smallint | ||
| 7. | ItemCode | NVarchar (50) | ||
| 8. | InQty | Decimal (21, 6) | ||
| 9. | OutQty | Decimal (21, 6) | ||
| 10. | Price | Decimal (21, 6) | ||
| 11. | Currency | NVarchar (3) | ||
| 12. | Rate | Decimal (21, 6) | ||
| 13. | TrnsfrAct | NVarchar (15) | ||
| 14. | PriceDifAc | NVarchar (15) | ||
| 15. | VarianceAc | NVarchar (15) | ||
| 16. | ReturnAct | NVarchar (15) | ||
| 17. | ExcRateAct | NVarchar (15) | ||
| 18. | ClearAct | NVarchar (15) | ||
| 19. | CostAct | NVarchar (15) | ||
| 20. | WipAct | NVarchar (15) | ||
| 21. | OpenStock | Decimal (21, 6) | ||
| 22. | CreateDate | Time Stamp | ||
| 23. | PriceDiff | Decimal (21, 6) | ||
| 24. | TransSeq | Integer | ||
| 25. | InvntAct | NVarchar (15) | ||
| 26. | SubLineNum | Integer | ||
| 27. | AppObjLine | Integer | ||
| 28. | Expenses | Decimal (21, 6) | ||
| 29. | OpenExp | Decimal (21, 6) | ||
| 30. | Allocation | Decimal (21, 6) | ||
| 31. | OpenAlloc | Decimal (21, 6) | ||
| 32. | ExpAlloc | Decimal (21, 6) | ||
| 33. | OExpAlloc | Decimal (21, 6) | ||
| 34. | OpenPDiff | Decimal (21, 6) | ||
| 35. | ExchDiff | Decimal (21, 6) | ||
| 36. | OpenEDiff | Decimal (21, 6) | ||
| 37. | NegInvAdjs | Decimal (21, 6) | ||
| 38. | OpenNegInv | Decimal (21, 6) | ||
| 39. | NegStckAct | NVarchar (15) | ||
| 40. | BTransVal | Decimal (21, 6) | ||
| 41. | VarVal | Decimal (21, 6) | ||
| 42. | BExpVal | Decimal (21, 6) | ||
| 43. | CogsVal | Decimal (21, 6) | ||
| 44. | BNegAVal | Decimal (21, 6) | ||
| 45. | IOffIncAcc | NVarchar (15) | ||
| 46. | IOffIncVal | Decimal (21, 6) | ||
| 47. | DOffDecAcc | NVarchar (15) | ||
| 48. | DOffDecVal | Decimal (21, 6) | ||
| 49. | DecAcc | NVarchar (15) | ||
| 50. | DecVal | Decimal (21, 6) | ||
| 51. | WipVal | Decimal (21, 6) | ||
| 52. | WipVarAcc | NVarchar (15) | ||
| 53. | WipVarVal | Decimal (21, 6) | ||
| 54. | IncAct | NVarchar (15) | ||
| 55. | IncVal | Decimal (21, 6) | ||
| 56. | ExpCAcc | NVarchar (15) | ||
| 57. | CostMethod | NVarchar (1) | ||
| 58. | MessageID | Integer | ||
| 59. | LocType | Integer | ||
| 60. | LocCode | NVarchar (8) | ||
| 61. | UserSign | Smallint | ||
| 62. | DataSource | NVarchar (1) | ||
| 63. | PostStatus | NVarchar (1) | ||
| 64. | SumStock | Decimal (21, 6) | ||
| 65. | OpenCogs | Decimal (21, 6) | ||
| 66. | OpenQty | Decimal (21, 6) | ||
| 67. | TreeID | Integer | ||
| 68. | ParentID | Integer | ||
| 69. | PAOffAcc | NVarchar (15) | ||
| 70. | PAOffVal | Decimal (21, 6) | ||
| 71. | OpenPAOff | Decimal (21, 6) | ||
| 72. | PAAcc | NVarchar (15) | ||
| 73. | PAVal | Decimal (21, 6) | ||
| 74. | OpenPA | Decimal (21, 6) | ||
| 75. | LinkArc | NVarchar (1) | ||
| 76. | VersionNum | NVarchar (13) | ||
| 77. | BSubLineNo | Integer | ||
| 78. | WipDebCred | NVarchar (1) |
