SAP Table TINV_INV_DOC - Billing Doc. Data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
INT_INV_DOC_NO X INV_INT_INV_DOC_NO NUMC 3 18 0 Internal Number of Bill Document/Payment Advice Document
INT_INV_NO INV_INT_INV_NO NUMC 21 18 0 Internal Bill/Payment Advice Number
DOC_NR INV_DOC_NR CHAR 40 1 0 Consecutive Number of Document for a Document Header
EXT_PARTNER BU_BPEXT CHAR 44 20 0 Business Partner Number in External System
INT_IDENT_TYPE INV_INT_IDENT_TYPE NUMC 64 2 0 Type of Internal Identifier
INT_IDENT INV_INT_IDENT CHAR 66 50 0 Internal Document Identification
INT_PARTNER BU_PARTNER CHAR 116 10 0 Business Partner Number
INVOICE_DATE INV_INVOICE_DATE CHAR 126 1 0 Bill/Payment Advice Note Date
INVPERIOD_START INV_PERIOD_START CHAR 134 1 0 Start of Validity Period for Bill/PAN
INVPERIOD_END INV_PERIOD_END CHAR 142 1 0 End fo Validity Period for Bill/PAN
EXT_INVOICE_NO INV_EXT_INVOICE_NO CHAR 150 40 0 External Bill/Payment Advice Note Number
DOC_TYPE INV_DOC_TYPE CHAR 190 1 0 Document Type
DATE_OF_PAYMENT INV_DATE_OF_PAYMENT CHAR 193 1 0 Due Date
PAYMENTDATE INV_PAYMENTDATE CHAR 201 1 0 Payment Date
VTREF VTREF_KK CHAR 209 20 0 Reference Specifications from Contract
CURRENCY WAERS CUKY 229 5 0 TCURC Currency Key
INV_DOC_STATUS INV_DOC_STATUS NUMC 234 2 0 Document Status
INT_INV_BKID INV_INT_INV_BKID CHAR 236 22 0 Internal Bank Details Key
INV_BVT INV_BVT CHAR 258 1 0 Bank Details ID for Sender
INT_INV_BKID_R INV_INT_INV_BKID CHAR 262 22 0 Internal Bank Details Key
INV_BVT_R INV_BVT_R CHAR 284 1 0 Bank Details ID for Recipient
INV_CANCEL_RSN INV_CANCEL_RSN CHAR 288 2 0 Reversal Reason
INV_CANCEL_DOC INV_INT_INV_CANCEL_DOC_NO NUMC 290 18 0 Number of Document Reversed by Current Document
CREATED_BY ERNAM CHAR 308 12 0 Name of Person who Created the Object
CREATED_ON ERDAT DATS 320 8 0 Date on Which Record Was Created
CHANGED_BY AENAM CHAR 328 12 0 Name of Person Who Changed Object
CHANGED_ON AEDAT DATS 340 8 0 Changed On
INVOICE_TYPE INV_INVOICE_TYPE NUMC 348 3 0 TINV_C_ITYPEDOCT Type of Bill / Type of Payment Advice Note
RSTGR RSTGR CHAR 351 3 0 T053R Reason Code for Payments
INV_BULK_REF INV_BULK_REF CHAR 354 22 0 Data Exchange Group Reference Number
EXT_INV_NO_ORIG INV_EXT_INVOICE_NO_ORIG CHAR 376 40 0 Original External Bill/PAN Number