| 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 | ADVPAYSPLITGUID | GUID for Cash Flow Record and Calculation Period | varbinary | 16 | 0 | RAW | | No | | RERAADVPAYSPLITGUID | |
| 3 | OBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECAOBJNR | Allow NULL? |
| 4 | CFGUID | Link to Cash Flow | varbinary | 16 | 0 | RAW | | Yes | | RERAADVPAYCFGUID | |
| 5 | WHEREFROM | Origin of Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAADVPAYWHEREFROM | Allow NULL? |
| 6 | VALIDFROM | Date: Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECADATEFROM | Allow NULL? |
| 7 | VALIDTO | Date: Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECADATETO | Allow NULL? |
| 8 | VALIDDAYS | Period in Days | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RERAVALIDDAYS | Allow NULL? |
| 9 | CONDGUID | GUID (RAW16) for Conditions | varbinary | 16 | 0 | RAW | | Yes | | RECDCONDGUID | |
| 10 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCDCONDTYPE | RECDCONDTYPE | Allow NULL? |
| 11 | TERMNOPY | Number of Posting Term | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RECDTERMNOPY | Allow NULL? |
| 12 | CDSPLITNO | Number of Condition Split | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RETMCDSPLITNO | Allow NULL? |
| 13 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCDFLOWTYPE | RECDFLOWTYPE | Allow NULL? |
| 14 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 15 | PARTNEROBJNR | Object Number for Internal Use | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RETMPARTNEROBJNR | Allow NULL? |
| 16 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 17 | NETAMOUNT | Net Amount in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERANETAMOUNT | |
| 18 | TAXAMOUNT | Tax Amount in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERATAXAMOUNT | |
| 19 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVRATAXTYPE | RERATAXTYPE | Allow NULL? |
| 20 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | TIVRATAXGROUP | RERATAXGROUP | Allow NULL? |
| 21 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCD | Allow NULL? |
| 22 | TAXDATE | Date for defining tax rates | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TXDAT | Allow NULL? |
| 23 | ISPAYED | Item Was Already Paid | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAISPAYED | Allow NULL? |
| 24 | USEDBYPROCESS | Generic Key of Process | varbinary | 16 | 0 | RAW | | Yes | | RECAPROCESSGUID | |
| 25 | USEDUNPAIDAP | Leave Unpaid Advance Payments Open (Planned Principle)? | char | 1 | 0 | CHAR | (N' ') | Yes | | RERATAKEOPENAP | Allow NULL? |
| 26 | USEDFROM | Valid-From Date of Current Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RERAADVPAYUSEDFROM | Allow NULL? |
| 27 | USEDTO | Valid-To Date of Current Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RERAADVPAYUSEDTO | Allow NULL? |
| 28 | USEDDAYS | Period in Days | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RERAUSEDDAYS | Allow NULL? |
| 29 | USEDNETAMOUNT | Net Amount of Current Period | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYUSEDNETAMOUNT | |
| 30 | USEDTAXAMOUNT | Tax Amount of Current Period | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYUSEDTAXAMOUNT | |
| 31 | RESTFROM | Valid-From Date for Calculating Remaining Share | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RERAADVPAYRESTFROM | Allow NULL? |
| 32 | RESTTO | Valid-To Date for Calculating Remaining Share | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RERAADVPAYRESTTO | Allow NULL? |
| 33 | RESTNETAMOUNT | Net Amount of Remaining Share | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYRESTNETAMOUNT | |
| 34 | RESTTAXAMOUNT | Tax Amount of Remaining Share | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAADVPAYRESTTAXAMOUNT | |
| 35 | REFGUID | Reference GUID | varbinary | 16 | 0 | RAW | | Yes | | RERAREFGUID | |
| 36 | RESTREFGUID | Reference GUID | varbinary | 16 | 0 | RAW | | Yes | | RERARESTREFGUID | |
| 37 | OBJGUID | GUID of Account Assignment Object, Assigned by Process | varbinary | 16 | 0 | RAW | | Yes | | RERAOBJGUID | |
| 38 | CTRULE | Currency Translation Rule | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | RECACTRULE | Allow NULL? |
| 39 | CTRATE | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | RECACTRATE | |
| 40 | CTFCCURRKEY | Foreign Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RECACTFCCURRKEY | Allow NULL? |
| 41 | CTFCNETAMOUNT | Net Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCNETAMOUNT | |
| 42 | CTFCTAXAMOUNT | Tax Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCTAXAMOUNT | |
| 43 | USEDCTFCNETAMT | Net Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCNETAMOUNT | |
| 44 | USEDCTFCTAXAMT | Tax Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCTAXAMOUNT | |
| 45 | RESTCTFCNETAMT | Net Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCNETAMOUNT | |
| 46 | RESTCTFCTAXAMT | Tax Amount of Advance Payment in Foreign Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERAAPCTFCTAXAMOUNT | |
| 47 | CTFCPOST | Post in Foreign Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | RECACTFCPOST | Allow NULL? |
| 48 | CALCMETHPER | Calculation Method for Time-Dependent Periods | char | 1 | 0 | CHAR | (N' ') | Yes | | RERACALCMETHPER | Allow NULL? |
| 49 | USECF4POST | Use Periodic Posting Run for Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAUSECF4POST | Allow NULL? |
