| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Numerator | int | 11 | 0 | | | | Allow NULL? |
| 2 | PeriodDate | Period Date | date | 8 | 0 | | | | |
| 3 | UserSign | User Signature | int | 6 | 0 | | | | Allow NULL? |
| 4 | CreateDate | Archive Date | date | 8 | 0 | | | | |
| 5 | CreateTime | Archive Time | int | 6 | 0 | | | | Allow NULL? |
| 6 | VersionNum | Version Number | int | 11 | 0 | | | | Allow NULL? |
| 7 | JEPerLen | Journal Entry Period Length | char | 1 | 0 | | A | A=Period, M=Month, S=Sub-period | Allow NULL? |
| 8 | JERef1 | Journal Entry Reference 1 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 9 | JERef2 | Journal Entry Reference 2 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 10 | JEMemo | Journal Entry Remarks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 11 | JEByProj | Journal Entry By Project | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 12 | JEByProf | Journal Entry By Dist. Rule | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | INPerLen | Inventory Period Length | char | 1 | 0 | | A | A=Period, M=Month, S=Sub-period | Allow NULL? |
| 14 | INPriceSrc | Inventory Price Source | int | 6 | 0 | OPLN | | | Allow NULL? |
| 15 | INRef1 | Inventory Reference 1 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 16 | INRef2 | Inventory Reference 2 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 17 | INMemo | Inventory Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 18 | JEByCurr | Journal Entry by Currency | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 19 | JEByDIM2 | Journal Entry by Dimension 2 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 20 | JEByDIM3 | Journal Entry by Dimension 3 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | JEByDIM4 | Journal Entry by Dimension 4 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 22 | JEByDIM5 | Journal Entry by Dimension 5 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | DBReduc | DB Reduction (MB) | num | 19 | 6 | | | | Allow NULL? |
| 24 | DBReducPer | DB Reduction (%) | num | 19 | 6 | | | | Allow NULL? |
| 25 | TrandReduc | Transaction Reduction | int | 11 | 0 | | | | Allow NULL? |
| 26 | TranReducP | Transaction Reduction (%) | num | 19 | 6 | | | | Allow NULL? |
| 27 | INZeroPrc | Inventory Zero Price | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 28 | TranRedArP | Trans. Reduc. Archived (%) | num | 19 | 6 | | | | Allow NULL? |
| 29 | DelNonReco | Delete nonreconciled OBNK lns | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | RunName | Data Archive Run Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 31 | RODBGUID | Readonly DB GUID for Archiving | nvarchar | 32 | 0 | | | | Allow NULL? |
| 32 | ArchMethod | Archive Method | char | 1 | 0 | | F | B=By Business Partner, F=By Financial Period | Allow NULL? |
