| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | PeriodCat | Period Category | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | FinancYear | Beginning of Financial Year | date | 8 | 0 | | | | |
| 4 | Year | Financial Year | int | 6 | 0 | | | | Allow NULL? |
| 5 | PeriodName | Period Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 6 | SubType | Sub-Period Type | char | 1 | 0 | | Y | D=Days, M=Months, Q=Quarters, Y=Year | Allow NULL? |
| 7 | PeriodNum | Number of Periods | int | 11 | 0 | | | | Allow NULL? |
| 8 | F_RefDate | Posting Date From | date | 8 | 0 | | | | |
| 9 | T_RefDate | Posting Date To | date | 8 | 0 | | | | |
| 10 | F_DueDate | Due Date From | date | 8 | 0 | | | | |
| 11 | T_DueDate | Due Date To | date | 8 | 0 | | | | |
| 12 | F_TaxDate | Document Date From | date | 8 | 0 | | | | |
| 13 | T_TaxDate | Document Date To | date | 8 | 0 | | | | |
| 14 | LogInstanc | Log Instance | int | 11 | 0 | | | | Allow NULL? |
| 15 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 16 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 17 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 18 | ResCode | Resource No. | nvarchar | 50 | 0 | ORSC | | | Allow NULL? |
| 19 | ResGrpCod | Resource Group | int | 6 | 0 | ORSB | | | Allow NULL? |
| 20 | WhsCode | Warehouse Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | BPGrpCod | BP Group | int | 6 | 0 | | | | Allow NULL? |
| 22 | LicTradNum | Federal Tax ID | nvarchar | 32 | 0 | | !^| | !^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID | Allow NULL? |
| 23 | ShipCountr | Ship-To Country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | ShipState | Ship-To State | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | Comments | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 26 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 27 | RuleCode | Advanced Rule Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 28 | GLMethod | Get G/L Account By | char | 1 | 0 | | A | A=General, C=Resource Group, W=Warehouse | Allow NULL? |
| 29 | Transfered | Year Transfer [Y/N] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | FromDate | From Date | date | 8 | 0 | | | | |
| 31 | ToDate | To Date | date | 8 | 0 | | | | |
| 32 | ResRevAct | Resource Revenue Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 33 | ResExpAct | Resource Expense Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 34 | ResSaleAct | Resource Sales Credit Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 35 | ResPurAct | Resource Purchase Credit Acct | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 36 | ResNInvAct | Resource Received Not Inv. Acct | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 37 | ResStdExp1 | Resource Std. Cost Expense 1 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 38 | ResStdExp2 | Resource Std. Cost Expense 2 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 39 | ResStdExp3 | Resource Std. Cost Expense 3 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 40 | ResStdExp4 | Resource Std. Cost Expense 4 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 41 | ResStdExp5 | Resource Std. Cost Expense 5 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 42 | ResStdExp6 | Resource Std. Cost Expense 6 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 43 | ResStdExp7 | Resource Std. Cost Expense 7 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 44 | ResStdExp8 | Resource Std. Cost Expense 8 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 45 | ResStdExp9 | Resource Std. Cost Expense 9 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 46 | ResStdEx10 | Resource Std. Cost Expense 10 | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 47 | ResWipAct | Resource WIP Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 48 | ResScrapAc | Scrap Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 49 | WipOffPlAc | WIP Offset P&L Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 50 | ResOffPlAc | Resource Offset P&L Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 51 | Active | Is Rule Active | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 52 | CmpPrivate | Company/Private | char | 1 | 0 | | A | A=All, C=Company, I=Private | Allow NULL? |
| 53 | VatGroup | Tax Definition | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 54 | CardCode | Customer/Vendor Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 55 | Usage | Usage Code for Document | int | 11 | 0 | OUSG | | | Allow NULL? |