| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ADVPAYEXTGUID | GUID for Object and Period of Advance Payment | varbinary | 16 | 0 | RAW | | No | | RERAADVPAYEXTGUID | |
| 3 | OBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECAOBJNR | Allow NULL? |
| 4 | ADD_OBJNR | Object Number for Additional Account Assignment | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RERAADDOBJNR | Allow NULL? |
| 5 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCDCONDTYPE | RECDCONDTYPE | Allow NULL? |
| 6 | CONDVALIDFROM | Date from when condition is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECDVALIDFROM | Allow NULL? |
| 7 | VALIDFROM | Period Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODFROM | Allow NULL? |
| 8 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 9 | PARTNEROBJNR | Object Number for Internal Use | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RETMPARTNEROBJNR | Allow NULL? |
| 10 | VALIDTO | Date: Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECADATETO | Allow NULL? |
| 11 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 12 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCDFLOWTYPE | RECDFLOWTYPE | Allow NULL? |
| 13 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVRATAXTYPE | RERATAXTYPE | Allow NULL? |
| 14 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | TIVRATAXGROUP | RERATAXGROUP | Allow NULL? |
| 15 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCD | Allow NULL? |
| 16 | TAXDATE | Date for defining tax rates | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TXDAT | Allow NULL? |
| 17 | USESPECGLIND | Special G/L Indicator Is Used | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAUSESPECGLIND | Allow NULL? |
| 18 | ACCSYSTEM | Definition of Accounting System | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVRAACCSYSTEM | RERAACCSYSTEM | Allow NULL? |
| 19 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYSTEM | Allow NULL? |
| 20 | REFDOCTYPE | Reference to Document Class | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | RERAREFDOCTYPE | Allow NULL? |
| 21 | REFDOCID | Reference Key of Document | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RERAREFDOCID | Allow NULL? |
| 22 | REFITEMNO | Accounting Document Line Item Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | POSNR_ACC | Allow NULL? |
| 23 | NETAMOUNT | Legacy Data Transfer: Net Amount of Advanced Payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYNETEXT | |
| 24 | TAXAMOUNT | Legacy Data Transfer: Tax Amount of Advanced Payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYTAXEXT | |
| 25 | ISINCLINCF | Advance Payment Included in Cash Flow | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAISINCLINCF | Allow NULL? |
| 26 | WHEREFROM | Origin of Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAADVPAYWHEREFROM | Allow NULL? |
