| 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=A/R Invoice, 15=Delivery, 16=Returns, 17=Sales Order | Allow NULL? |
| 8 | PostDate | Posting Date | date | 8 | 0 | | | | |
| 9 | TaxDate | Document Date | date | 8 | 0 | | | | |
| 10 | Series | Series | int | 11 | 0 | | | | Allow NULL? |
| 11 | Items | Items Documents Summary | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 12 | ItemSmmry | Items Summary Method | char | 1 | 0 | | N | D=Summary by Documents, I=Summary by Items, N=No Summary | Allow NULL? |
| 13 | Service | Service Documents Summary | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 14 | ServSmmry | Service Summary Method | char | 1 | 0 | | N | D=Summary by Documents, N=No Summary | Allow NULL? |
| 15 | ExchgRate | Exchange Rate | char | 1 | 0 | | C | B=Use Base Row Rate, C=Use Current Rate, D=Use Base Doc. and Row Rate | Allow NULL? |
| 16 | CreatDraft | Create Drafts | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 17 | BaseQUT | Sales Quotation Summary | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 18 | BaseRDR | Order Summary | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 19 | BaseDLN | Delivery Summary | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 20 | BaseRDN | Returns Summary | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | BaseResINV | A/R Reserve Invoice Summary | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 22 | ExpndSel | Expanded Selection Criteria | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | SortField | Sort Field | nvarchar | 100 | 0 | | DocNum | DocDate=Posting Date, DocDueDate=Due Date, DocNum=Document Number, DocTotal=Document Amount, NumAtCard=BP Reference No., SlpCode=Sales Employee | Allow NULL? |
| 24 | Consolidat | Consolidate | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 25 | ExpandCons | Expanded Consolidation Options | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 26 | RCNSummary | Reference Document | char | 1 | 0 | | N | N=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 31 | Indirect | Indirect | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 32 | DoReport | Overview of Invoice Deliveries | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 33 | FileExport | File Export | char | 1 | 0 | | N | N=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 37 | NoItmCode | Drop Item No. Where Cat. No. E | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 38 | OnData | Missing Data | char | 1 | 0 | | N | B=Skip to Next Customer, N=Skip to Next Document, W=Ask for User Confirmation | Allow NULL? |
| 39 | OnLedger | Bookkeeping Alert | char | 1 | 0 | | N | B=Skip to Next Customer, N=Skip to Next Document, W=Ask for User Confirmation | Allow NULL? |
| 40 | OnInvnt | Warehouse Alert | char | 1 | 0 | | N | B=Skip to Next Customer, N=Skip to Next Document, W=Ask for User Confirmation | Allow NULL? |
| 41 | Summary | Summary | nvarchar | 250 | 0 | | | | Allow NULL? |
| 42 | AltItmDocs | Process docsc with alt. items | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 43 | PartDelivr | Partial Delivery | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 44 | ConsiderBP | Consider BP | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 45 | ConsiderTy | Consider Type | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 46 | EDocGenTyp | Electr. Doc. Generation Type | char | 1 | 0 | | D | D=Use Defaults, G=Generate, L=Generate - Later, N=Not Relevant, R=Send - Later, S=Send | 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=No, Y=Yes | Allow NULL? |
| 50 | ReopManCls | Reop. Man. Closed/Canc. Orders | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 51 | SeqCode | Target Doc. NF Sequence Code | int | 6 | 0 | | | | Allow NULL? |
| 52 | UseBaseSeq | Use Base Document NF Sequence | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 53 | OnSeqCode | Missing NF Sequence | char | 1 | 0 | | N | N=Skip to Next Document, T=Use NF Sequence from Step 2 | Allow NULL? |
| 54 | BPLId | Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
| 55 | BlckFrOnly | Block Docs. with Zero Items | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 56 | DocSubType | Document Sub-Type | nvarchar | 2 | 0 | | -- | --=Bill of Supply, GA=GST Tax Invoice | Allow NULL? |
| 57 | EDocDflt | Apply El. Doc. Defaults | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
