| 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 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | INVOICE_NO | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | DOC_ITEM | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 6 | CUSTOMER | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 7 | BILLING_DOC | Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VF | Allow NULL? |
| 8 | POSTING_DATE | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 9 | INV_DATE | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 10 | DUE_DATE | Net Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDT_FPOS | Allow NULL? |
| 11 | INV_DUE_DATE | Net Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDT_FPOS | Allow NULL? |
| 12 | DISCOUNT_DATE | Due Date for Cash Discount 1 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SK1DT | Allow NULL? |
| 13 | PAYMENT_DATE | Date of Last Incoming Payment for Invoice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FDM_LAST_PAYMENT_DATE | Allow NULL? |
| 14 | DUNNING_DATE | Date of Last Dunning Notice for Invoice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FDM_LAST_DUNNING_DATE | Allow NULL? |
| 15 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 16 | INVOICE_AMOUNT | Original Amount of Invoice or Credit | decimal | 15 | 2 | CURR | ((0)) | Yes | | FDM_INVOICE_AMOUNT | |
| 17 | PAID_AMOUNT | Amount Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | BDM_PAID_AMOUNT | |
| 18 | OPEN_AMOUNT | Open Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | FDM_OPEN_AMOUNT | |
| 19 | CREDITED_AMOUNT | Total of All Credits for Selected Invoice | decimal | 13 | 2 | CURR | ((0)) | Yes | | FDM_CREDIT_AMOUNT | |
| 20 | DUNNING_AMOUNT | Dunned Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | FDM_DUNNING_AMOUNT | |
| 21 | PAYMENT_ARRANGED | Amount Arranged for Payment | decimal | 13 | 2 | CURR | ((0)) | Yes | | FDM_PAYMENT_ARRANGED | |
| 22 | DISCOUNT_AMOUNT | Cash discount amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WSKTO | |
| 23 | COLL_DEBITOR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 24 | TIMESTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
