| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | SrcObjType | Source Object Type | nvarchar | 20 | 0 | | -1 | -1, 112=Document Draft, 123=Checks for Payment Drafts, 140=Payment Draft, 15=Delivery notes, 16=Revert Delivery Notes, 17=Sales Order, 20=Goods Receipt, 21=Goods Return, 22=Purchase order, 23=Sales Quotation, 28=Journal Batches, 540000006=Purchase Quotation, 59=Goods Receipt, 60=Goods Issue | Allow NULL? |
| 3 | SrcObjAbs | Source Object Internal ID | int | 11 | 0 | | -1 | | Allow NULL? |
| 4 | OrdinLNum | Ordial Num (BTF & Canceled) | int | 11 | 0 | | -1 | | Allow NULL? |
| 5 | Cancelled | Canceled | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |