| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | ObjectType | Object Type | nvarchar | 20 | 0 | | 22 | | Allow NULL? |
| 3 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 4 | RefType | Reference Types | char | 1 | 0 | | S | E=External Document, S=System Document | Allow NULL? |
| 5 | LineNum | Line Number | int | 11 | 0 | | | | Allow NULL? |
| 6 | RefDocEntr | Referenced Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 7 | RefDocNum | Referenced Document Number | int | 11 | 0 | | | | Allow NULL? |
| 8 | ExtDocNum | External Referenced Document Number | nvarchar | 100 | 0 | | | | Allow NULL? |
| 9 | RefObjType | Referenced Object Type | nvarchar | 20 | 0 | | | -1=External Document, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery Notes, 163=A/P Correction Invoice, 165=A/R Correction Invoice, 16=Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 202=Production Order, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 234000031=Re | Allow NULL? |
| 10 | AccessKey | Access Key | nvarchar | 100 | 0 | | | | Allow NULL? |
| 11 | IssueDate | Date of Issue | date | 8 | 0 | | | | |
| 12 | IssuerCNPJ | Issuer CNPJ | nvarchar | 100 | 0 | | | | Allow NULL? |
| 13 | IssuerCode | Fiscal Document Issuer UF Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | Model | Fiscal Document Model | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | Series | Fiscal Document Series | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | Number | Fiscal Document Number | int | 11 | 0 | | | | Allow NULL? |
| 17 | RefAccKey | Referenced CT-e Access Key | nvarchar | 100 | 0 | | | | Allow NULL? |
| 18 | RefAmount | Referenced Amount | num | 19 | 6 | | | | Allow NULL? |
| 19 | SubSeries | Fiscal Document Subseries | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | Remark | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 21 | LinkRefTyp | Link Reference Type | nvarchar | 20 | 0 | | 00 | 00, 01=Nota de crédito de los documentos relacionados, 02=Nota de débito de los documentos relacionados, 03=Devolución de mercancía sobre facturas o traslados previos, 04=Sustitución de los CFDI previos, 05=Traslados de mercancias facturados previamente, 06=Factura generada por los traslados previos, 07=CFDI por aplicación de anticipo, 08= | Allow NULL? |
