| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | SetName | Set Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | SetDesc | Set Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 4 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 5 | ModifyDate | Last Modified | date | 8 | 0 | | | | |
| 6 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 7 | Target | Target Document Type | nvarchar | 20 | 0 | | -1 | -1, 13, 15, 16, 17 | Allow NULL? |
| 8 | PostDate | Posting Date | date | 8 | 0 | | | | |
| 9 | TaxDate | Document Date | date | 8 | 0 | | | | |
| 10 | Series | Series | int | 6 | 0 | | | | Allow NULL? |
| 11 | Items | Items Documents Summary | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 12 | ItemSmmry | Items Summary Method | char | 1 | 0 | | N | D, I, N | Allow NULL? |
| 13 | Service | Service Documents Summary | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 14 | ServSmmry | Service Summary Method | char | 1 | 0 | | N | D, N | Allow NULL? |
| 15 | ExchgRate | Exchange Rate | char | 1 | 0 | | C | B, C, D | Allow NULL? |
| 16 | CreatDraft | Create Drafts | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 17 | BaseQUT | Sales Quotation Summary | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 18 | BaseRDR | Order Summary | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 19 | BaseDLN | Delivery Summary | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 20 | BaseRDN | Returns Summary | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 21 | BaseResINV | A/R Reserve Invoice Summary | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 22 | ExpndSel | Expanded Selection Criteria | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 23 | SortField | Sort Field | nvarchar | 100 | 0 | | DocNum | DocDate, DocDueDate, DocNum, DocTotal, NumAtCard, SlpCode | Allow NULL? |
| 24 | Consolidat | Consolidate | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 25 | ExpandCons | Expanded Consolidation Options | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 26 | RCNSummary | Reference Document | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 27 | ChainCode | Retail Chain | int | 11 | 0 | | | | Allow NULL? |
| 28 | OredrNum1 | Order No. From | int | 11 | 0 | | | | Allow NULL? |
| 29 | OredrNum2 | To | int | 11 | 0 | | | | Allow NULL? |
| 30 | Direct | Direct | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 31 | Indirect | Indirect | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 32 | DoReport | Overview of Invoice Deliveries | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 33 | FileExport | File Export | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 34 | SavePath | File Path | text | 16 | 0 | | | | |
| 35 | DealNum | Closing No. | nvarchar | 12 | 0 | | | | Allow NULL? |
| 36 | UseDirect | Direct/Indirect | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 37 | NoItmCode | Drop Item No. Where Cat. No. E | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 38 | OnData | Missing Data | char | 1 | 0 | | N | B, N, W | Allow NULL? |
| 39 | OnLedger | Bookkeeping Alert | char | 1 | 0 | | N | B, N, W | Allow NULL? |
| 40 | OnInvnt | Warehouse Alert | char | 1 | 0 | | N | B, N, W | Allow NULL? |
| 41 | Summary | Summary | nvarchar | 250 | 0 | | | | Allow NULL? |
| 42 | AltItmDocs | Process docsc with alt. items | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 43 | PartDelivr | Partial Delivery | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 44 | ConsiderBP | Consider BP | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 45 | ConsiderTy | Consider Type | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 46 | EDocGenTyp | Electr. Doc. Generation Type | char | 1 | 0 | | N | G, L, N | Allow NULL? |
| 47 | ESeries | Electronic Series | int | 6 | 0 | NNM4 | | | Allow NULL? |
| 48 | EDocNum | Electronic Document Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 49 | ReopOriRdr | Reopen Origin. Order by Return | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 50 | ReopManCls | Reop. Man. Closed/Canc. Orders | char | 1 | 0 | | N | N, Y | Allow NULL? |
