| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | GJAHR | Posting year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR_KK | Allow NULL? |
| 4 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | DFKKKO_SHORT | SH_OPBEL_KK | Allow NULL? |
| 5 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN | Allow NULL? |
| 6 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR1 | Allow NULL? |
| 7 | WAERK | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERK | Allow NULL? |
| 8 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 9 | EXPKZ | Export indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | EXPKZ | Allow NULL? |
| 10 | FKART | Billing Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FKART | Allow NULL? |
| 11 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FKDAT | Allow NULL? |
| 12 | FKSTO | Billing document is cancelled | char | 1 | 0 | CHAR | (N' ') | Yes | | FKSTO | Allow NULL? |
| 13 | INCO1 | Incoterms (Part 1) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | INCO1 | Allow NULL? |
| 14 | INCO2 | Incoterms (Part 2) | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | INCO2 | Allow NULL? |
| 15 | KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSM_D | Allow NULL? |
| 16 | KUNAG | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNAG | Allow NULL? |
| 17 | KUNRG | Payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNRG | Allow NULL? |
| 18 | SFAKN | Cancelled billing document number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SFAKN | Allow NULL? |
| 19 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP | Allow NULL? |
| 20 | NETWR | Value of invoice | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXW_NETWR | Allow NULL? |
| 21 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 22 | AWKEY | Reference Key | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AWKEY | Allow NULL? |
| 23 | BSTNK_VF | Customer purchase order number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD | Allow NULL? |
| 24 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 25 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 26 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 27 | LAND1 | Country of Destination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LLAND | Allow NULL? |
| 28 | LANDTX | Tax departure country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LANDTX | Allow NULL? |
| 29 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
