| 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
|