| 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, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 163=Correction A/P Invoice, 164=Correction A/P Invoice Reversals, 165=Correction A/R Invoice, 166=Correction A/R Invoice Reversals, 18=A/P Invoice, 19=A/P Credit Memo, 24=Incoming Payment, 25=Deposit, 30=Journal Transaction, 321=In | 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? |