Mapping - Advanced

Remittance

Used to provide remittance information.  The Invoice_Number_RMR and Amount_Payment_RMR are always used.

Type_RMR

Do not map unless otherwise instructed to.  Default is set to 'IV' = Invoice. The default can be set on the CTX setup window to Invoice, Purchase Order or Accounts Receivable Open item. If importing different types in the same file, use the following two character abbreviations:

IV - Invoice

PO - Purchase Order

R7 - A/R Open Item

Notes:

--If you want to include both an invoice and purchase order number, leave the default alone as invoice - and use the reference section below as the purchase order.

--To specify a default not listed above, simply enter it in the CTX setup window.

Invoice_Number_RMR

Invoice number, or number as identified in Type_RMR

Amount_Payment_RMR

Amount to be paid

Amount_Total_Invoice_RMR

Used when the total invoice amount is different from the amount paid.  Difference can be accounted for in either an adjustment (example - back order, short shipment, damaged goods), or from use of payment discount (example 2% 10, net 30)

Amount_Discount_RMR

Used to indicate amount taken as a prompt payment discount (example 2% 10, net 30).  Do not use this field to show other adjustments.

Reference

Used when a purchase order (or other information) number is supplied in addition to the invoice number in the remittance segment.

Type_REF

Default setting is 'PO', and can be updated on the CTX setup window.

If importing different types in the same file, use the following two character abbreviations:

PO - Purchase Order

R7 - A/R Open Item

BM - Bill of lading

VV  - Voucher

Note: To specify a default not listed above, simply enter it in the CTX setup window.

PO_Number_REF

Purchase order number, or number as identified in Type_REF

PO_Description_REF

Free form description.  As with all descriptions, do not use an asterisk or backslash.

Trace

Enables you to reference the transaction back to your internal system.  An example would be a check number to an accounts payable system

Trace_TRN

Trace number (actually an alphanumeric field).

Date/Time

Used to specify the date of the information in the remittance (RMR) tag.

Type_DTM

Do not map unless otherwise instructed to.  Default is set to '003' = Invoice. The default can be set on the CTX setup window to Invoice, Purchase Order or Contract Effective. If importing different types in the same file, use the following three digit abbreviations:

003 - Invoice

004 - Purchase Order

092 - Contract Effective

Date_DTM

Use local settings - US MM/DD/YYYY; UK DD/MM/YYYY.

Adjustments

Used to transmit payer-generated debit/credit memos.

Adjustment_Amount_ADX

Amount.  Sign is stripped away and is determined by 'type' below.

Note: The following equation should be true - the system will not alter your entries:

Amount_Payment_RMR = Amount_Total_Invoice_RMR -  Amount_Discount_RMR +/- Adjustment_Amount_ADX

Adjustment_Type_ADX

Two character code indicating debit or credit memo:

Adjustment_Description_ADX

Alphanumeric description

Name

Name_Full_NM1

Individual or organization name.  Do not map unless otherwise instructed to - as it can be duplicative of the N1 segment.