| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | REGIO | Region of Document Issuer | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | NFYEAR | Year of Document Date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | NFMONTH | Month of Document Date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | | | Allow NULL? |
| 6 | MODEL | Model of Nota Fiscal | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | SERIE | Series | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 9 | DOCNUM9 | Random Number in Access Key | nvarchar | 9 | 0 | | | | Allow NULL? |
| 10 | CDV | Check Digit in Access Key | char | 1 | 0 | | | | Allow NULL? |
| 11 | POSNR | Document Item Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | MENGE | Quantity in Unit of Entry | decimal | 13 | 3 | | | | |
| 15 | MEINS | Unit of Entry | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | MEINS_ISO | Unit of entry in ISO code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | NFNET | Net price | decimal | 16 | 6 | | | | |
| 18 | NFFRE | Freight value including taxes | decimal | 15 | 2 | | | | |
| 19 | NFINS | Insurance value including taxes | decimal | 15 | 2 | | | | |
| 20 | NFOTH | Expenses including taxes | decimal | 15 | 2 | | | | |
| 21 | NFDIS | Discount value including taxes | decimal | 15 | 2 | | | | |
| 22 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | PEINH | Price Unit | decimal | 5 | 0 | | | | |
| 24 | BPRME | Order Price Unit (Purchasing) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | CFOP | CFOP Code and Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | MATORG | Origin of the material | char | 1 | 0 | | | | Allow NULL? |
| 28 | FCI | FCI Number | nvarchar | 36 | 0 | | | | Allow NULL? |