Data for Deposit and Payment Import Maintenance is stored in the ar-import table.
|
Field |
Field Name |
|
Source |
import-source |
|
Bank Account |
import-gl-acct-ptr |
|
Customer Code |
payer-customer-key |
|
Format ID |
format-id |
|
Default |
format-default |
|
Use Automatic Payment Algorithms |
use-payment-algorithms |
|
Type |
import-type |
|
File Format |
import-format |
|
Delimiter |
import-format |
|
Max Blank Lines |
max-blank-lines |
|
Payment Amount Column Letter/Number |
payment-amount-column |
|
Payment Amount Import Sign |
payment-amount-plus |
|
Payment ID Column Letter/Number |
payment-id-column |
|
Payment Date Column Letter/Number |
payment-date-column |
|
ABA/RT# Column Letter/Number |
aba-number-column |
|
Bank Account # Column Letter/Number |
acct-number-column |
|
Customer Code Column Letter/Number |
cust-code-column |
|
Reference # Column Letter/Number |
ref-num-column |
|
Amount Column Letter/Number |
ref-amt-column |
|
Amount Import Sign |
ref-amt-plus |
|
Credit Amount Column Letter/Number |
ref-credit-amt-column |
|
Credit Amount Import Sign |
ref-credit-amt-plus |
|
Discount Amount Column Letter/Number |
discount-amt-column |
|
Discount Amount Import Sign |
discount-amt-plus |
|
Store ID Column Letter/Number |
store-id-column |
|
PO # Column Letter/Number |
cust-po-number-column |
|
Use PO # to Apply |
use-po-to-apply |
|
Cust CB Reason Code Column Letter/Number |
cust-ref-code-column |
|
Billing Customer Code Column Letter/Number |
billing-customer-column |