| 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 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | LOGSYS | Allow NULL? |
| 3 | DOCID | Document Ledger Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | /OPT/DOCID | Allow NULL? |
| 4 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 5 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 7 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 8 | VEND_NAME | Name 1 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_GP | Allow NULL? |
| 9 | VEND_NAME_NORMED | Name 1 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_GP | Allow NULL? |
| 10 | VEND_NAME2 | Name 2 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME2_GP | Allow NULL? |
| 11 | PYMNT_TERMS | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 12 | PYMNT_TERMS_TEXT | Payment Terms text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /OPT/PAY_TERM_TEXT | Allow NULL? |
| 13 | REMIT_STREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | No | | AD_STREET | Allow NULL? |
| 14 | REMIT_HSNM1 | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 15 | REMIT_PSTLZ | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 16 | REMIT_LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 17 | REMIT_AD_CITY1 | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 18 | REMIT_REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 19 | REMIT_PO_BOX | PO Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_POBX | Allow NULL? |
| 20 | REMIT_PSTL2 | P.O. Box Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTL2 | Allow NULL? |
| 21 | STATUS | Document Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | /OPT/DOCSTATUS | Allow NULL? |
| 22 | STATUS_TXT | Supplier Self Service Status Texts | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/W_3S_STATUS_TXT_DE | Allow NULL? |
| 23 | STATUS_EXT | External Invoice Status (Artificial Key) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /OPT/EEXTSTATUSID_DE | Allow NULL? |
| 24 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR | Allow NULL? |
| 25 | XBLNR_NORMED | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR | Allow NULL? |
| 26 | GROSS_AMOUNT | Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | /OPT/RMWWR | |
| 27 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 28 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 29 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 30 | CHANGE_DATE | Document Change Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /OPT/DOCCHDATE | Allow NULL? |
| 31 | CHANGE_TIME | Document Change Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /OPT/DOCCHTIME | Allow NULL? |
| 32 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
