| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | BaseEntry | Base Document Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | LineNum | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | Canceled | Canceled | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 4 | DocType | Document Type | char | 1 | 0 | | I | C=Correction Invoice, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment | Allow NULL? |
| 5 | RefEntry1 | Ref.1 Document Key | int | 11 | 0 | | | | Allow NULL? |
| 6 | RefEntry2 | Ref.1 Document Key | int | 11 | 0 | | | | Allow NULL? |
| 7 | ObjType | Object Type | int | 6 | 0 | ADP1 | | | Allow NULL? |
| 8 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 9 | RefType | Ref. Object Type | int | 11 | 0 | | -1 | -1, 13=A/R Invoice, 163=A/P Correction Invoice, 165=A/R Correction Invoice, 18=A/P Invoice, 204=A/P Down Payment, 24=Incoming Payment, 30=Journal Entry, 69=Landed Cost | Allow NULL? |