| 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 | OBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | RECAOBJNR | Allow NULL? |
| 3 | ADD_OBJNR | Object Number for Additional Account Assignment | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | RERAADDOBJNR | Allow NULL? |
| 4 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | TIVCDCONDTYPE | RECDCONDTYPE | Allow NULL? |
| 5 | VALIDTO | Date: Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RECADATETO | Allow NULL? |
| 6 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BU_PARTNER | Allow NULL? |
| 7 | PARTNEROBJNR | Object Number for Internal Use | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | RETMPARTNEROBJNR | Allow NULL? |
| 8 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | RAW | | Yes | * | RECAPROCESSGUID | |
| 9 | OBJGUID | GUID of Account Assignment Object, Assigned by Process | varbinary | 16 | 0 | RAW | | Yes | | RERAOBJGUID | |
| 10 | VALIDFROM | Period Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODFROM | 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 | NET_AMOUNT | Net Amount of Advanced Payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYNET | |
| 18 | TAX_AMOUNT | Tax Amount of Advance Payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYTAX | |
| 19 | NET_AMOUNT_PAY | Amount of Net Advance Payment Made (for Settlement) | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYNETAMOUNT | |
| 20 | TAX_AMOUNT_PAY | Tax Amount of Advance Payment Made (for Settlement) | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYTAXAMOUNT | |
| 21 | NET_AMOUNT_EXT | Legacy Data Transfer: Net Amount of Advanced Payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYNETEXT | |
| 22 | TAX_AMOUNT_EXT | Legacy Data Transfer: Tax Amount of Advanced Payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYTAXEXT | |
| 23 | TERMTYPE | Term Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVTMTERMTYPE | RETMTERMTYPE | Allow NULL? |
| 24 | TERMNO | Term Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RETMTERMNO | Allow NULL? |
| 25 | CONDGUID | GUID (RAW16) for Conditions | varbinary | 16 | 0 | RAW | | Yes | | RECDCONDGUID | |
| 26 | TERMNOPY | Number of Posting Term | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RECDTERMNOPY | Allow NULL? |
| 27 | CDSPLITNO | Number of Condition Split | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RETMCDSPLITNO | Allow NULL? |
| 28 | HASLEGACYDATA | Uses Legacy Data | char | 1 | 0 | CHAR | (N' ') | Yes | | RECAHASLEGACYDATA | Allow NULL? |
| 29 | PROCESSMODE | Execution Mode of Process | char | 1 | 0 | CHAR | (N' ') | Yes | | RECAPROCESSMODE | Allow NULL? |
| 30 | STATUS | Status of Advance Payment Relevant to SCS | char | 1 | 0 | CHAR | (N' ') | Yes | | RERASEAPSTATUS | Allow NULL? |
| 31 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | RECACTRULE | Allow NULL? |
| 32 | CTRATE | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | RECACTRATE | |
| 33 | CTFCCURRKEY | Foreign Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECACTFCCURRKEY | Allow NULL? |
| 34 | CTFCNETAMOUNT | Net Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCNETAMOUNT | |
| 35 | CTFCTAXAMOUNT | Tax Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCTAXAMOUNT | |
| 36 | CTFCNETAMOUNTPAY | Net Amount of Advance Payment Made in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCNETAMOUNTPAY | |
| 37 | CTFCTAXAMOUNTPAY | Tax Amount of Advance Payment Made in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCTAXAMOUNTPAY | |
| 38 | CTFCNETAMOUNTEXT | Legacy Data Transfer: AP Net Amount in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCNETAMOUNTEXT | |
| 39 | CTFCTAXAMOUNTEXT | Legacy Data Transfer: AP Tax Amount in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCTAXAMOUNTEXT | |
| 40 | CTFCPOST | Post in Foreign Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | RECACTFCPOST | Allow NULL? |
