| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | |||
| DocNum | Document Number | Int | 11 | - | |||
| DocDate | Posting Date | Date | 8 | - | |||
| DocDueDate | Due Date | Date | 8 | - | |||
| CardCode | Vendor Code | nVarChar | 15 | OCRD | |||
| SuppName | Vendor Name | nVarChar | 200 | - | |||
| AgentCode | Subst. Code | nVarChar | 15 | OCRD | |||
| AgentName | Subst. Name | nVarChar | 200 | - | |||
| DocStatus | Document Status | VarChar | 1 | - | O | C | Closed |
| O | Open | ||||||
| AgentNum | File Number | nVarChar | 16 | - | |||
| Descr | Remarks | nVarChar | 250 | - | |||
| Ref1 | Reference 1 | nVarChar | 11 | - | |||
| Ref2 | Reference 2 | nVarChar | 11 | - | |||
| DocCur | Document Currency | nVarChar | 3 | - | |||
| DocRate | Document Rate | Num | 19.6 | - | |||
| ExpCustom | Projected Customs | Num | 19.6 | - | |||
| ActCustom | Act. Import Duty | Num | 19.6 | - | |||
| Vat1 | Tax 2 | Num | 19.6 | - | |||
| Vat2 | Tax 2 | Num | 19.6 | - | |||
| BeforeVat | Total Before Tax | Num | 19.6 | - | |||
| DocTotal | Document Total | Num | 19.6 | - | |||
| CostSum | Total Costs | Num | 19.6 | - | |||
| DocTime | Generation Time | Int | 6 | - | |||
| Canceled | Canceled | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| ExCustomFC | Projected Customs (FC) | Num | 19.6 | - | |||
| AcCustomFC | Act. Import Duty in FC | Num | 19.6 | - | |||
| Vat1FC | Tax 1 (FC) | Num | 19.6 | - | |||
| Vat2FC | Tax 2 (FC) | Num | 19.6 | - | |||
| BeforVatFC | Total Before Tax (FC) | Num | 19.6 | - | |||
| DocTotalFC | Document Total (FC) | Num | 19.6 | - | |||
| CostSumFC | Total Costs (FC) | Num | 19.6 | - | |||
| CloseDate | Closing Date | Date | 8 | - | |||
| Cost_Match | Expenses Diff. for Reconciliation | Num | 19.6 | - | |||
| C_Match_FC | Expenses Diff. for Recon. (FC) | Num | 19.6 | - | |||
| BillOfLad | Bill of Lading No. | nVarChar | 20 | - | |||
| TrnspCode | Delivery Category | Int | 6 | OSHP | |||
| CostFactor | Expenses Factor | Num | 19.6 | - | |||
| UpdateDate | Date of Update | Date | 8 | - | |||
| CreateDate | Creation Date | Date | 8 | - | |||
| Transfered | Year Transfer | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| Instance | Instance | Int | 6 | - | 0 | ||
| TaxDate | Document Date | Date | 8 | - | |||
| Series | Series | Int | 11 | - | |||
| JdtNum | Journal Number | Int | 11 | OJDT | |||
| JdtMemo | Transaction Details | nVarChar | 254 | - | |||
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| I | Interface | ||||||
| U | Update | ||||||
| M | Import | ||||||
| O | DI API | ||||||
| S | Service Layer | ||||||
| W | Web Client | ||||||
| A | Doc. Generation Wizard | ||||||
| D | Restore Wizard | ||||||
| P | Partner Implementation | ||||||
| T | Year Transfer | ||||||
| UserSign | User Signature | Int | 6 | OUSR | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 | 69 | ||
| ExCustomSC | Projected Customs (SC) | Num | 19.6 | - | |||
| ActCustSC | Actual Customs (SC) | Num | 19.6 | - | |||
| TtlCostSC | Total Expenditure (SC) | Num | 19.6 | - | |||
| VersionNum | Version Number | nVarChar | 13 | - | |||
| OpenForLaC | Open For Landed Costs | VarChar | 1 | - | Y | Y | Yes |
| N | No | ||||||
| incCustom | Include Customs Expenses | VarChar | 1 | - | Y | ||
| SeqCode | Sequence Code | Int | 6 | - | |||
| Serial | Serial Number | Int | 11 | - | |||
| SeriesStr | Series String | nVarChar | 3 | - | |||
| SubStr | Subseries String | nVarChar | 3 | - | |||
| BuildDesc | Build Descriptor | nVarChar | 50 | - | |||
| SupplCode | Supplementary Code | nVarChar | 254 | - | |||
| AtcEntry | Attachment Entry | Int | 11 | - | |||
| CustDate | Customs Date | Date | 8 | - | |||
| BPLId | Branch | Int | 11 | OBPL | |||
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| D | Erased | ||||||
| EncryptIV | Encrypt IV | nVarChar | 100 | - | |||
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| NUM | Yes | DocNum |
| Instance | ||
| Series | ||
| SUPPLIER | No | CardCode |
| AGENT | No | AgentCode |
| AgentNum | ||
| CURRENCY | No | DocCur |
| SERIES | No | Series |