SAP Table TINV_INV_LINE_A - Payment Advice Line

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_LINE_NO X INV_INT_INV_LINE_NO NUMC 21 8 0 Line Item Number of Bill/Payment Advice Note Document
BETRW INV_BETRW_GROSS CURR 29 13 2 Gross Amount in Transaction Currency with +/- Sign
BETRW_NET INV_BETRW_NET CURR 36 13 2 Net Amount in Transaction Currency with +/- Sign
BETRW_REQ INV_REQ_BETRW_GROSS CURR 43 13 2 Requested Gross Amount in Transaction Currency
BETRW_SKONTO INV_BETRW_SKONTO CURR 50 13 2 Cash Discount Amount in Transaction Currency with +/+ Sign
CURRENCY WAERS CUKY 57 5 0 TCURC Currency Key
TAXBW INV_TAXBW CURR 62 13 2 Tax Amount in Transaction Currency
STPRZ STRPZ_KK_1 DEC 69 6 0 Tax rate
MWSKZ MWSKZ CHAR 73 2 0 Sales Tax Code
DATE_OF_PAYMENT INV_DATE_OF_PAYMENT CHAR 75 1 0 Due Date
PAYMENTDATE INV_PAYMENTDATE CHAR 83 1 0 Payment Date
EXT_LINE_NO INV_EXT_LINE_NO CHAR 91 1 0 External Document Line Item Number
DATE_FROM INV_DATE_FROM CHAR 97 1 0 Start of Period
DATE_TO INV_DATE_TO CHAR 105 1 0 End of Period
LINE_TYPE INV_LINE_TYPE NUMC 113 4 0 TINV_C_LINETYPE Line Type
TRANSF_RELEVANT INV_KZ_TRANSF_RELEVANT CHAR 117 1 0 Relevant to Transfer
TRANSF_DONE INV_KZ_TRANSF_DONE CHAR 118 1 0 Data Transferred
RSTGR RSTGR CHAR 119 3 0 T053R Reason Code for Payments
INT_IDENT_TYPE INV_INT_IDENT_TYPE NUMC 122 2 0 Type of Internal Identifier
INT_IDENT INV_INT_IDENT CHAR 124 50 0 Internal Document Identification
EXT_PARTNER BU_BPEXT CHAR 174 20 0 Business Partner Number in External System
INT_PARTNER BU_PARTNER CHAR 194 10 0 Business Partner Number
EXT_INVOICE_NO INV_EXT_DOC_NO_ADVICE CHAR 204 40 0 External Document Number
OWN_INVOICE_NO INV_OWN_INVOICE_NO CHAR 244 40 0 Internal Document Number
VTREF VTREF_KK CHAR 284 20 0 Reference Specifications from Contract
CONTRACT INV_CONTRACT CHAR 304 10 0 Contract
VKONT_PAY INV_VKONT_PAY CHAR 314 12 0 Contract Account for Payment
BVRKO INV_BVRKO CHAR 326 10 0 Clearing Account for Aggregation/Payment Distribution