| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | LogEntry | Log Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | TransId | Transaction ID | int | 11 | 0 | | | | Allow NULL? |
| 3 | ItemCode | Item Code | nvarchar | 20 | 0 | OITM | | | Allow NULL? |
| 4 | ItemName | Item Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 5 | ManagedBy | Management Method | int | 11 | 0 | | 4 | 10000044=BTN, 10000045=SRN, 4=ITM | Allow NULL? |
| 6 | DocEntry | Document Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 7 | DocLine | Doc. Row Number | int | 11 | 0 | | | | Allow NULL? |
| 8 | DocType | Transact. Type | int | 11 | 0 | | -1 | | Allow NULL? |
| 9 | DocNum | Doc. Number | int | 11 | 0 | | | | Allow NULL? |
| 10 | BaseEntry | Base Document Internal ID | int | 11 | 0 | | -1 | | Allow NULL? |
| 11 | BaseLine | Base Document Row Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 12 | BaseType | Base Document Type | int | 11 | 0 | | -1 | -1, 0, 13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales | Allow NULL? |
| 13 | ApplyEntry | Applied Document Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 14 | ApplyLine | Applied Document Line Number | int | 11 | 0 | | | | Allow NULL? |
| 15 | ApplyType | Applied Document Type | int | 11 | 0 | | -1 | | Allow NULL? |
| 16 | DocDate | Doc. Posting Date | date | 8 | 0 | | | | |
| 17 | CardCode | BP Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 18 | CardName | BP Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 19 | DocQty | Doc. Quantity | num | 19 | 6 | | | | Allow NULL? |
| 20 | StockQty | Stock Affecting Quantity | num | 19 | 6 | | | | Allow NULL? |
| 21 | DefinedQty | SnB Defined Quantity | num | 19 | 6 | | | | Allow NULL? |
| 22 | StockEff | Stock Effect | int | 11 | 0 | | 0 | 0=ACCUM_EMPTY, 1=ACCUM_ON_HAND, 2=ACCUM_COMMITTED | Allow NULL? |
| 23 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 24 | LocType | Location Type | int | 6 | 0 | | | | Allow NULL? |
| 25 | LocCode | Location Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | AppDocNum | Applied Document Number | int | 11 | 0 | | | | Allow NULL? |
| 27 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 28 | Transfered | Year Tranfer | char | 1 | 0 | | N | | Allow NULL? |
| 29 | Instance | INSTANCE | int | 6 | 0 | | 0 | | Allow NULL? |
| 30 | SubLineNum | Subrow Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 31 | BSubLineNo | Base Subrow Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 32 | AppSubLine | Applied Subrow Number | int | 11 | 0 | | -1 | | Allow NULL? |