| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Key | int | 11 | 0 | PHA1 | | | Allow NULL? |
| 2 | LineID | Row No. | int | 11 | 0 | | | | Allow NULL? |
| 3 | StageID | Stage ID | int | 11 | 0 | PHA1 | | | Allow NULL? |
| 4 | TYP | Document Type | int | 11 | 0 | | -1 | -1=Please select, 13002=A/R Reserve Invoice, 13=A/R Invoice, 1470000113=Purchase Request, 14=A/R Credit Memo, 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=Return, 17=Sales Order, 18002=A/P Reserve Invoice, 18=A/P Invoice, 191=Service Call, | Allow NULL? |
| 5 | DOCNUM | Document Number | int | 11 | 0 | | | | Allow NULL? |
| 6 | DocEntry | Document Abs. Entry | int | 11 | 0 | | | | Allow NULL? |
| 7 | DocDate | Document Date | date | 8 | 0 | | | | |
| 8 | Total | Total | num | 19 | 6 | | | | Allow NULL? |
| 9 | LineNum | Line Number | int | 11 | 0 | | | | Allow NULL? |
| 10 | Status | Line status | char | 1 | 0 | | O | C=Closed, O=Open | Allow NULL? |
| 11 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 12 | AmountCat | Category to which we will apply the amount from Total | char | 1 | 0 | | | I=Invoiced, O=Open | Allow NULL? |
| 13 | Categorize | Category Open Amount/Invoiced A/R, A/P to which we will apply the amount from journal entry | nvarchar | 2 | 0 | | | IP=Invoiced (A/P), IR=Invoiced (A/R), OP=Open Amount (A/P), OR=Open Amount (A/R) | Allow NULL? |
| 14 | Operation | Operation which we will apply to the amount from the total | char | 1 | 0 | | | A=Add, S=Subtract | Allow NULL? |
| 15 | Chargeable | Chargeable [Yes/No] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 16 | Charged | Charged | num | 19 | 6 | | | | Allow NULL? |
| 17 | ChargedQty | Charged Quantity | num | 19 | 6 | | | | Allow NULL? |
| 18 | DocType | Document Type | char | 1 | 0 | | I | I=Item, S=Service | Allow NULL? |
