| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | Code | Code | nvarchar | 8 | 0 | OECM | | | Allow NULL? |
| 3 | LineNum | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 4 | ObjType | Object Type | nvarchar | 20 | 0 | | -1 | 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 18=A/P Invoice, 19=A/P Credit Memo, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 24=Incoming Payment, 46=Outgoing Payment | Allow NULL? |
| 5 | ObjXPath | Object Type XPath | nvarchar | 254 | 0 | | | | Allow NULL? |
| 6 | FieldType | Field Type | char | 1 | 0 | | T | A=Additional ID, C=CNPJ, I=IBAN, L=Alias Name, N=BP Name, T=Federal Tax ID, U=Unified Federal Tax ID | Allow NULL? |
| 7 | FieldXPath | Field XPath | nvarchar | 254 | 0 | | | | Allow NULL? |
| 8 | ImportFmt | Import Format | int | 11 | 0 | OLLF | | | Allow NULL? |
| 9 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 10 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 11 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 12 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 13 | LogInstanc | Log Instance | int | 6 | 0 | | | | Allow NULL? |