Import Cash Receipts Table Maps
The following tables detail the table and file mapping associated with running the Import Cash Receipts preprocessor.
CASH_RECPT_HDR Table Map
| Table Column |
Contents |
| CASH_RECPT_HDR_KEY |
System assigned |
| FY_CD |
From preprocessor screen |
| PD_NO |
From preprocessor screen |
| CASH_RECPT_NO |
System assigned or from the preprocessor screen |
| SUB_PD_NO |
From preprocessor screen |
| ENTR_USER_ID |
Log-in user ID |
| ENTR_DTT |
System date |
| S_JNL_CD |
CR |
| POST_SEQ_NO |
Null |
| RECPT_DT |
From EDI file: BPR (820) and DEP (823) |
| MODIFIED_BY |
Log-in User ID |
| TIME_STAMP |
System date and time |
| COMPANY_ID |
Log-in company |
| ADVANCE_FL |
N |
| PAY_CRNCY_CD |
Functional currency of log-in company |
| PAY_CRNCY_DT |
From RECPT_DT |
| RATE_GRP_ID |
Default rate group |
| TRN_TO_EUR_RT |
1 |
| EUR_TO_FUNC_RT |
1 |
| TRN_TO_EUR_RT_FL |
N |
| TRN_FREEZE_RT_FL |
N |
| BANK_DEPOSIT_NO |
From EDI file: DEP (823) |
| OVR_BUD_FL |
N |
| DOC_LOCATION |
Left blank |
| ROWVERSION |
0 |
CASH_RECPT_TRN Table Map
| Table Column |
Contents |
| CASH_RECPT_HDR_KEY |
System assigned |
| CASH_RECPT_TRN_KEY |
System assigned |
| LN_NO |
System assigned (1 for cash account and 1 foe billed A/R) |
| ACCT_ID |
Billed A/R and RCV_ACCT_ID from AR_HDR_HS |
| ORG_ID |
RCV_ORG_ID from AR_HDR_HS |
| ORG_ABBRV_CD |
ORG_ABBRV_CD from ORG |
| PROJ_ID |
PROJ_ID from AR_HDR_HS |
| PROJ_ABBRV_CD |
PROJ_ABBRV_CD from PROJ |
| REF1_ID |
RCV_REF1_ID from AR_HDR_HS |
| REF2_ID |
RCV_REF2_ID from AR_HDR_HS |
| INVC_ID |
From EDI file RMR02 |
| CUST_ID |
From EDI file N102 |
| CR_CHK_ID |
From EDI file REF02 (823 only) |
| TRN_DESC |
Account name |
| DISC_TAKEN_AMT |
From EDI file RMR06 |
| TRN_AMT |
From EDI file RMR04 |
| MODIFIED_BY |
Log-in user ID |
| TIME_STAMP |
System data and time |
| BANK_ACCT_ABBRV |
From cash account in AR_SETTINGS |
| VEND_ID |
Left blank |
| TVL_ADV_ID |
Left blank |
| TVL_ADV_HDR_KEY |
Left blank |
| TVL_ADV_LN_KEY |
Left blank |
| CASH_ACCT_LINE_FL |
Left blank |
| S_LINE_SOURCE_CD |
I for 'invoice' |
| PAY_TRN_AMT |
Map from TRN_AMT |
| PAY_DISC_TAKEN_AMT |
Map from DISC_TAKEN_AMT |
| TRN_TRN_AMT |
From PAY_TRN_AMT |
| TRN_DISC_TAKEN_AMT |
From PAY_DISC_TAKEN_AMT |
| MU_REAL_GAIN_AMT |
Zero by system default (no multicurrency) |
| MU_REAL_LOSS_AMT |
Zero by system default (no multicurrency) |
| PROJ_ACCT_ABBRV_CD |
Left blank |
| TRN_FINCHG_RCV_AMT |
System calculation as per AR settings |
| PAY_FINCHG_RCV_AMT |
System calculation as per AR settings |
| FINCHG_RCV_AMT |
System calculation as per AR settings |
| ROWVERSION |
System default |
| EXP_RPT_ID |
Left blank |
Parent Topic:
Related Topics for the Import Cash Receipts Screen
