Chargeback Redistribute Database Information

Data for Chargeback Redistribute is stored in multiple tables.

Fields

Field

Field Name/Table

Billing Customer Code

billing-customer-key in customer-ar

Batch #

batch-id in ar-gl

Chargeback Reference #

ref-num + ref-suffix in ar-chrgbcks & ar-open

A/R Account

gl-acct-ptr in ar-open

Currency

entered-currency in ar-open

Main Tab Fields

Field

Field Name/Table

Cust Ref#

cust-ref-num in ar-open

Amount

orig-amt & open-amt in ar-open, amount in ar-trans

Cust Reason Code

chrgbck-cust-reason-key in ar-chrgbcks

Reason Code

chrgbck-reason-key in ar-chrgbcks

Status Code

chrgbck-status-key in ar-chrgbcks

Chargeback Date

chrgbck-date in ar-chrgbcks

Reference Date

ref-date in ar-open

Due Date

due-date in ar-open

Expiration Date

expire-date in ar-chrgbcks

Cust P/O #

cust-po-number in ar-open

Cust RA#

ra-num in ar-open

Store ID

store-id in ar-chrgbcks

Related Invoice Ref#

related-ref-num in ar-chrgbcks

Billing Customer Code

billing-customer-key in ar-chrgbcks & ar-open

Customer Code

cust-key in ar-open

A/R Account

gl-acct-ptr in ar-open

Other Information Tab Fields

Field

Field Name/Table

Chargeback User Defined 1-10

user-defined-01-10 in ar-chrgbcks