| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | INT_TRANSF_NO | Internal ID of Transfer Line | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | nvarchar | 18 | 0 | | | | Allow NULL? |
| 4 | INT_INV_LINE_NO | Line Item Number of Bill/Payment Advice Note Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | DATE_OF_RECEIPT | Document Date of Receipt | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | INVOICE_DATE | Bill/Payment Advice Note Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | THBLN_EXT | Aggregated Document Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | THBLN_TYPE | Document Number Type | char | 1 | 0 | | | | Allow NULL? |
| 10 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | THPRD | Actual Date for Transfer to Third Party | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | THPDT | Planned date for transfer of payment to third party | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | THPST | Entry status | char | 1 | 0 | | | | Allow NULL? |
| 14 | WAERS | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 16 | TAXBW | Tax Amount in Transaction Currency | decimal | 13 | 2 | | | | |
| 17 | STPRZ | Tax rate | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | RECEIVER_TYPE | Type of Bill/PAN Recipient | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | INT_RECEIVER | Internal Description of Bill/Payment Advice Recipient | nvarchar | 15 | 0 | | | | Allow NULL? |
| 21 | SENDER_TYPE | Type of Bill/PAN Sender | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | INT_SENDER | Internal Description of Bill/Payment Advice Note Sender | nvarchar | 15 | 0 | | | | Allow NULL? |
| 23 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | | | | Allow NULL? |
| 26 | INVCAT | Bill Category of a General Ledger Account/Contract Account | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | LINE_TYPE | Line Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | LINE_CONTENT | Content of Bill/Payment Advice Note Line | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | INT_LINE_REF_NO | Internal Reference Number to Link Several Doc. Line Items | nvarchar | 18 | 0 | | | | Allow NULL? |
| 30 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | AUFNR | Order Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 32 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | QUANTITY | Quantity | decimal | 15 | 3 | | | | |
| 35 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | PAYLOCH | Payment Block Key | char | 1 | 0 | | | | Allow NULL? |
| 37 | PAYLOCV | Lock Reason for Automatic Payment | char | 1 | 0 | | | | Allow NULL? |
| 38 | INV_BVT | Bank Details ID for Sender | nvarchar | 4 | 0 | | | | Allow NULL? |
| 39 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 40 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | CHANGED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 42 | CHANGE_DATE | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | decimal | 13 | 2 | | | | |
| 44 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | | | | Allow NULL? |
| 46 | DPPRC | Down Payment Process for Supplier: Posting Category | char | 1 | 0 | | | | Allow NULL? |
| 47 | INVDUMMY | Checkbox | char | 1 | 0 | | | | Allow NULL? |
