List \ OGAR
Berikut ini adalah kolom yang terdapat pada tabel OGAR di SAP B1
Update: 2026-07-22
| No |
Nama Kolom |
Tipe Data |
Keterangan |
Referensi |
| 1. |
AbsEntry |
Integer |
Internal Number |
|
| 2. |
PeriodCat |
NVarchar (10) |
Period Category |
|
| 3. |
FinancYear |
Time Stamp |
Beginning of Financial Year |
|
| 4. |
Year |
Smallint |
Financial Year |
|
| 5. |
PeriodName |
NVarchar (20) |
Period Name |
|
| 6. |
SubType |
NVarchar (1) |
Sub-Period Type |
|
| 7. |
PeriodNum |
Integer |
Number of Periods |
|
| 8. |
F_RefDate |
Time Stamp |
Posting Date From |
|
| 9. |
T_RefDate |
Time Stamp |
Posting Date To |
|
| 10. |
F_DueDate |
Time Stamp |
Due Date From |
|
| 11. |
T_DueDate |
Time Stamp |
Due Date To |
|
| 12. |
F_TaxDate |
Time Stamp |
Document Date From |
|
| 13. |
T_TaxDate |
Time Stamp |
Document Date To |
|
| 14. |
LogInstanc |
Integer |
Log Instance |
|
| 15. |
UpdateDate |
Time Stamp |
Date of Update |
|
| 16. |
UserSign |
Smallint |
User Signature |
|
| 17. |
UserSign2 |
Smallint |
Updating User |
|
| 18. |
ItemCode |
NVarchar (50) |
Item No. |
|
| 19. |
ItmsGrpCod |
Smallint |
Item Group |
|
| 20. |
WhsCode |
NVarchar (8) |
Warehouse Code |
|
| 21. |
BPGrpCod |
Smallint |
BP Group |
|
| 22. |
LicTradNum |
NVarchar (32) |
Federal Tax ID |
|
| 23. |
ShipCountr |
NVarchar (3) |
Ship-to Country |
|
| 24. |
ShipState |
NVarchar (3) |
Ship-To State |
|
| 25. |
Comments |
NVarchar (254) |
Remarks |
|
| 26. |
CreateDate |
Time Stamp |
Creation Date |
|
| 27. |
RuleCode |
NVarchar (20) |
Advanced Rule Code |
|
| 28. |
GLMethod |
NVarchar (1) |
Get G/L Account By |
|
| 29. |
Transfered |
NVarchar (1) |
Year Transfer [Y/N] |
|
| 30. |
FromDate |
Time Stamp |
From Date |
|
| 31. |
ToDate |
Time Stamp |
To Date |
|
| 32. |
DfltExpn |
NVarchar (15) |
Expense Account |
|
| 33. |
DfltIncom |
NVarchar (15) |
Revenue Account |
|
| 34. |
ExmptIncom |
NVarchar (15) |
Tax Exempt Revenue Account |
|
| 35. |
StockAct |
NVarchar (15) |
Inventory Account |
|
| 36. |
COGM_Act |
NVarchar (15) |
Cost of Goods Sold Account |
|
| 37. |
AlocCstAct |
NVarchar (15) |
Allocation Account |
|
| 38. |
VariancAct |
NVarchar (15) |
Variance Account |
|
| 39. |
PricDifAct |
NVarchar (15) |
Price Difference Account |
|
| 40. |
NegStckAct |
NVarchar (15) |
Negative Inventory Adj. Acct |
|
| 41. |
DfltLoss |
NVarchar (15) |
Inventory Offset - Decr. Acct |
|
| 42. |
DfltProfit |
NVarchar (15) |
Inventory Offset - Incr. Acct |
|
| 43. |
RturnngAct |
NVarchar (15) |
Sales Returns Account |
|
| 44. |
ECIncome |
NVarchar (15) |
Revenue Account - EU |
|
| 45. |
ECExepnses |
NVarchar (15) |
Expense Account - EU |
|
| 46. |
ForgnIncm |
NVarchar (15) |
Revenue Account - Foreign |
|
| 47. |
ForgnExpn |
NVarchar (15) |
Expense Account - Foreign |
|
| 48. |
PurchseAct |
NVarchar (15) |
Purchase Account |
|
| 49. |
PaReturnAc |
NVarchar (15) |
Purchase Return Account |
|
| 50. |
PaOffsetAc |
NVarchar (15) |
Purchase Offset Account |
|
| 51. |
ExDiffAct |
NVarchar (15) |
Exchange Rate Differences Acct |
|
| 52. |
BalanceAct |
NVarchar (15) |
Goods Clearing Account |
|
| 53. |
DecresGlAc |
NVarchar (15) |
G/L Decrease Account |
|
| 54. |
IncresGlAc |
NVarchar (15) |
G/L Increase Account |
|
| 55. |
WipAcct |
NVarchar (15) |
WIP Inventory Account |
|
| 56. |
WipVarAcct |
NVarchar (15) |
WIP Inventory Variance Account |
|
| 57. |
WipOffset |
NVarchar (15) |
WIP Offset P&L Account |
|
| 58. |
StockOffst |
NVarchar (15) |
Inventory Offset P&L Account |
|
| 59. |
StockRvAct |
NVarchar (15) |
Inventory Revaluation Account |
|
| 60. |
StkRvOfAct |
NVarchar (15) |
Inventory Reval. Offset Acct |
|
| 61. |
CostRevAct |
NVarchar (15) |
COGS Revaluation Acct |
|
| 62. |
CostOffAct |
NVarchar (15) |
COGS Revaluation Offset Acct |
|
| 63. |
ExpClrAct |
NVarchar (15) |
Expense Clearing Account |
|
| 64. |
ExpOfstAct |
NVarchar (15) |
Expense Offset Account |
|
| 65. |
StkInTnAct |
NVarchar (15) |
Stock In Transit Account |
|
| 66. |
ShpdGdsAct |
NVarchar (15) |
Shipped Goods Account |
|
| 67. |
VatRevAct |
NVarchar (15) |
VAT in Revenue Account |
|
| 68. |
ARCMAct |
NVarchar (15) |
Sales Credit Account |
|
| 69. |
APCMAct |
NVarchar (15) |
Purchase Credit Account |
|
| 70. |
ARCMExpAct |
NVarchar (15) |
Tax Exempt Credit Account |
|
| 71. |
ARCMFrnAct |
NVarchar (15) |
Sales Credit Account - Foreign |
|
| 72. |
APCMFrnAct |
NVarchar (15) |
Purchase Credit Acct - Foreign |
|
| 73. |
ARCMEUAct |
NVarchar (15) |
Sales Credit Account - EU |
|
| 74. |
APCMEUAct |
NVarchar (15) |
Purchase Credit Account - EU |
|
| 75. |
PurBalAct |
NVarchar (15) |
Purchase Balance Account |
|
| 76. |
WhICenAct |
NVarchar (15) |
Incoming CENVAT Account (WH) |
|
| 77. |
WhOCenAct |
NVarchar (15) |
Outgoing CENVAT Account (WH) |
|
| 78. |
Active |
NVarchar (1) |
Is Rule Active |
|
| 79. |
CmpPrivate |
NVarchar (1) |
Company/Private/Government |
|
| 80. |
VatGroup |
NVarchar (8) |
Tax Definition |
|
| 81. |
CardCode |
NVarchar (15) |
Customer/Vendor Code |
|
| 82. |
Usage |
Integer |
Usage Code for Document |
|
| 83. |
FreeChrgSA |
NVarchar (15) |
Free of Charge Sales Account |
|
| 84. |
FreeChrgPU |
NVarchar (15) |
Free of Charge Purchase Account |
|
| 85. |
UDF1 |
NVarchar (254) |
|
|
| 86. |
UDF2 |
NVarchar (254) |
|
|
| 87. |
UDF3 |
NVarchar (254) |
|
|
| 88. |
UDF4 |
NVarchar (254) |
|
|
| 89. |
UDF5 |
NVarchar (254) |
|
|
