SAP table FDM_COLL_INVOICE (Data for Invoice Status)

Field Description Data Type Length Decimals Checktable Data Element
CUSTOMER Customer Number CHAR 10 0 KUNNR
COLL_DEBITOR Customer Number CHAR 10 0 KUNNR
COMP_CODE Company Code CHAR 4 0 BUKRS
INVOICE_NO Document Number of an Accounting Document CHAR 10 0 BELNR_D
DOC_ITEM Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
FISCAL_YEAR Fiscal Year NUMC 4 0 GJAHR
BILLING_DOC Billing Document CHAR 10 0 VBELN_VF
POSTING_DATE Posting Date in the Document DATS 8 0 BUDAT
INV_DATE Document Date in Document DATS 8 0 BLDAT
DUE_DATE Net Due Date DATS 8 0 FAEDT_FPOS
INV_DUE_DATE Net Due Date DATS 8 0 FAEDT_FPOS
DISCOUNT_DATE Due Date for Cash Discount 1 DATS 8 0 SK1DT
OVERDUE_BY Days in Arrears by Net Due Date DEC 5 0 VERZN
PAYMENT_DATE Date of Last Incoming Payment for Invoice DATS 8 0 FDM_LAST_PAYMENT_DATE
CURRENCY Currency Key CUKY 5 0 WAERS
INVOICE_AMOUNT Original Amount of Invoice or Credit CURR 15 2 FDM_INVOICE_AMOUNT
PAID_AMOUNT Amount Paid CURR 15 2 BDM_PAID_AMOUNT
OPEN_AMOUNT Open Amount CURR 15 2 FDM_OPEN_AMOUNT
CREDITED_AMOUNT Total of All Credits for Selected Invoice CURR 13 2 FDM_CREDIT_AMOUNT
DISPUTED_AMOUNT Disputed Amount CURR 13 2 FDM_DISPUTED_AMOUNT
DUNNING_AMOUNT Dunned Amount CURR 15 2 FDM_DUNNING_AMOUNT
DUNNING_LEVEL Dunning Level NUMC 1 0 MAHNS_D
DUNNING_DATE Date of Last Dunning Notice for Invoice DATS 8 0 FDM_LAST_DUNNING_DATE
PROMISED_AMOUNT Outstanding Amount Promised CURR 15 2 FDM_CURRENT_P2P_AMOUNT
P2P_LEVEL Level of Promise to Pay INT1 3 0 BDM_PROMISE_LEVEL
P2P_STATE State of Promise to Pay CHAR 1 0 BDM_PROMISE_STATE
0 Open
1 Broken
2 Partially Kept
3 Kept
4 Withdrawn
5 Not on Schedule
6 Partially Kept, Not on Schedule
7 Partially Kept, on Schedule
8 Kept, Not on Schedule
9 Kept, on Schedule
P2P_DUE_DATE Date for Which Payment Is Promised DATS 8 0 BDM_PROMISE_DUE_DATE
INST_IS_OVERDUE Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') CHAR 1 0 BOOLE_D
PAYMENT_ARRANGED Amount Arranged for Payment CURR 13 2 FDM_PAYMENT_ARRANGED
DISCOUNT_AMOUNT Cash Discount Amount in Document Currency CURR 13 2 WSKTO_CS
XBLNR Reference Document Number CHAR 16 0 XBLNR1
SAKNR G/L Account Number CHAR 10 0 SAKNR
MONAT Fiscal period NUMC 2 0 MONAT
EXT_KEY Case ID CHAR 12 0 FDM_EXT_KEY
STAT_ORDERNO Status of Dispute Case NUMC 2 0 FDM_STAT_ORDERNO
STATUS_DESCRIPTION Status of Dispute Case CHAR 30 0 FDM_STATUS_DESCRIPTION
REASON_CODE Reason for Dispute Case CHAR 4 0 FDM_REASON_CODE
REASON_CODE_DESCRIPTION Description of Reason CHAR 40 0 FDM_REASON_CODE_DESCRIPTION
CREATE_TIME Time of Creation of Dispute Case DEC 15 0 FDM_CREATE_TIME
NO_OF_RSM Number of Resubmissions INT4 10 0 FDM_INV_NO_OF_RSM
NO_OF_NTS Number of Notes INT4 10 0 FDM_INV_NO_OF_NTS
SPGL_IND Special G/L Indicator CHAR 1 0 UMSKZ
FDM_BSCHL Posting Key CHAR 2 0 BSCHL
FDM_SGTXT Item Text CHAR 50 0 SGTXT
FDM_MANSP Dunning Block CHAR 1 0 MANSP