TINV_INV_DOC - Billing Doc. Data
Billing Doc. Data information is stored in SAP table TINV_INV_DOC.
It is part of development package EE_INVOICE_RECEIPT in software component IS-U-IDE. This development package consists of objects that can be grouped under "Bill Receipt Checks".
It is part of development package EE_INVOICE_RECEIPT in software component IS-U-IDE. This development package consists of objects that can be grouped under "Bill Receipt Checks".
Fields for table TINV_INV_DOC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | * |
INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | X | INV_INT_INV_DOC_NO | NUMC | 36 | |
INT_INV_NO | Internal Bill/Payment Advice Number | INV_INT_INV_NO | NUMC | 36 | ||
DOC_NR | Consecutive Number of Document for a Document Header | INV_DOC_NR | INT4 | 4 | ||
EXT_PARTNER | Business Partner Number in External System | BU_BPEXT | CHAR | 40 | ||
INT_IDENT_TYPE | Type of Internal Identifier | INV_INT_IDENT_TYPE | NUMC | 4 | ||
INT_IDENT | Internal Document Identification | INV_INT_IDENT | CHAR | 100 | ||
INT_PARTNER | Business Partner Number | BU_PARTNER | CHAR | 20 | * | |
INVOICE_DATE | Bill/Payment Advice Note Date | INV_INVOICE_DATE | DATS | 16 | ||
INVPERIOD_START | Start of Validity Period for Bill/PAN | INV_PERIOD_START | DATS | 16 | ||
INVPERIOD_END | End fo Validity Period for Bill/PAN | INV_PERIOD_END | DATS | 16 | ||
EXT_INVOICE_NO | External Bill/Payment Advice Note Number | INV_EXT_INVOICE_NO | CHAR | 80 | ||
DOC_TYPE | Document Type | INV_DOC_TYPE | NUMC | 6 | TINV_C_DOCTYPE | |
DATE_OF_PAYMENT | Due Date | INV_DATE_OF_PAYMENT | DATS | 16 | ||
PAYMENTDATE | Payment Date | INV_PAYMENTDATE | DATS | 16 | ||
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 40 | ||
CURRENCY | Currency Key | WAERS | CUKY | 10 | * | |
INV_DOC_STATUS | Document Status | INV_DOC_STATUS | NUMC | 4 | ||
INT_INV_BKID | Internal Bank Details Key | INV_INT_INV_BKID | CHAR | 44 | ||
INV_BVT | Bank Details ID for Sender | INV_BVT | CHAR | 8 | ||
INT_INV_BKID_R | Internal Bank Details Key | INV_INT_INV_BKID | CHAR | 44 | ||
INV_BVT_R | Bank Details ID for Recipient | INV_BVT_R | CHAR | 8 | ||
INV_CANCEL_RSN | Reversal Reason | INV_CANCEL_RSN | CHAR | 4 | * | |
INV_CANCEL_DOC | Number of Document Reversed by Current Document | INV_INT_INV_CANCEL_DOC_NO | NUMC | 36 | ||
CREATED_BY | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
CREATED_ON | Date on which the record was created | ERDAT | DATS | 16 | ||
CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
CHANGED_ON | Last Changed On | AEDAT | DATS | 16 | ||
INVOICE_TYPE | Type of Bill / Type of Payment Advice Note | INV_INVOICE_TYPE | NUMC | 6 | * | |
RSTGR | Reason Code for Payments | RSTGR | CHAR | 6 | TINV_C_ADJ_RSN | |
.INCLUDE | CI_INVOICE_DOC | 0 | ||||
INV_BULK_REF | Data Exchange Group Reference Number | INV_BULK_REF | CHAR | 44 | ||
EXT_INV_NO_ORIG | Original External Bill/PAN Number | INV_EXT_INVOICE_NO_ORIG | CHAR | 80 |