| 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 | INVOICE_TYPE | Invoice Type | nvarchar | 5 | 0 | CHAR | (N' ') | No | * | /OPT/INVOICE_TYPE | Allow NULL? |
| 3 | INVOICE_KEY | Invoice Key | nvarchar | 20 | 0 | CHAR | (N' ') | No | | /OPT/INVOICE_KEY | Allow NULL? |
| 4 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/SYNC_FLAG | Allow NULL? |
| 5 | INV_NO | Document Number of an Invoice Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RE_BELNR | Allow NULL? |
| 6 | INV_TYPE | Invoice Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/INV_TYPE | Allow NULL? |
| 7 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 8 | INV_DATE | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 9 | TOTAL_AMT | Net Value in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | NETWR | |
| 10 | SIGN | Sign for positive (+) or negative(-) number | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/SIGN | Allow NULL? |
| 11 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 12 | TAX | Tax amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WMWST | |
| 13 | VENDOR_REF | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR | Allow NULL? |
| 14 | PAYMENT_DUE | Due Date for Net Payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NETDT | Allow NULL? |
| 15 | PAYMENT_DATE | Probable Payment Date (Cash Discount 1 Due) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZALDT | Allow NULL? |
| 16 | BASELINE_DATE | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZFBDT | Allow NULL? |
| 17 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EKKO | EBELN | Allow NULL? |
| 18 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 19 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 20 | REF_VENDOR | Account Number of the Branch | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FILKD | Allow NULL? |
| 21 | INV_STATUS | Invoice Status | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /OPT/STATMASTER | /OPT/INV_STATUS | Allow NULL? |
| 22 | INV_PARA1 | Status Parameter 1 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/STATUSPARA1 | Allow NULL? |
| 23 | INV_PARA2 | Status Parameter 2 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/STATUSPARA2 | Allow NULL? |
| 24 | INV_PARA3 | Status Parameter 3 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/STATUSPARA3 | Allow NULL? |
| 25 | INV_PARA4 | Status Parameter 4 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/STATUSPARA4 | Allow NULL? |
| 26 | INV_ADD_INFO | Invoice Status Additional Info | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | /OPT/INVADDLINFO | Allow NULL? |
| 27 | PAYMENTSTATUS | Payment Status | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /OPT/STATMASTER | /OPT/PAY_STATUS | Allow NULL? |
| 28 | PAYMENT_PARA1 | Payment Status Parameter 1 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/PAY_PARA1 | Allow NULL? |
| 29 | PAYMENT_PARA2 | Payment Status Parameter 2 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/PAY_PARA2 | Allow NULL? |
| 30 | PAYMENT_PARA3 | Payment Status Parameter 3 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/PAY_PARA3 | Allow NULL? |
| 31 | PAYMENT_PARA4 | Payment Status Parameter 4 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | /OPT/PAY_PARA4 | Allow NULL? |
| 32 | PAY_ADD_INFO | Payment Status Additional Info | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | /OPT/PAYADDLINFO | Allow NULL? |
| 33 | DELETED | Deleted flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/DELETED | Allow NULL? |
