DTCREDIT FILE
REFERENCED BY
AR37.8 DT170 DT180 DT181 DT92.1
UPDATED BY
AR44.3 DT150 DT45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DTX-COMPANY Numeric 4 AR44.3 DT150
Company The company number represents an
established company and is entered on
all function codes.
DTX-AR-DRAFT-NBR Alpha 22 AR44.3 DT150
Ar Draft Nbr
DTX-SUFFIX Numeric 3 AR44.3 DT150
Invoice Suffix This is the suffix for the invoice.
DTX-CUSTOMER Alpha 9 (Right Justified) AR44.3 DT150
Customer Number This field contains the number that
represents a customer.
DTX-CANCEL-SEQ Numeric 4 AR44.3 DT150
Cancel Sequence The sequence number assigned upon a DT45.1
cancellation of a distributed invoice.
The first sequence assigned is 9999.
DTX-DRAFT-SOURCE Alpha 1 AR44.3 DT150
Bill of Exchange This defines origination of the bill of
Source exchange.
DTX-APP-SEQ Numeric 5 AR44.3 DT150
App Seq
DTX-CR-COMPANY Numeric 4 AR44.3 DT150
Cr Company
DTX-CR-TYPE Alpha 1 AR44.3 DT150
Cr Type
DTX-CR-NBR Alpha 22 AR44.3 DT150
Credit Memo Number
DTX-CR-BATCH Numeric 6 AR44.3 DT150
Cr Batch
DTX-CR-PYMNT-SEQ Numeric 6 AR44.3 DT150
Cr Pymnt Seq
DTX-CR-CUSTOMER Alpha 9 (Right Justified) AR44.3 DT150
Cr Customer
DTX-CR-APP-SEQ Numeric 5 AR44.3 DT150
Cr App Seq
DTCREDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DTXSET1 COMPANY AR37.8 DT170
AR-DRAFT-NBR DT180 DT181
SUFFIX DT45.1 DT45.2
CUSTOMER DT92.1
CANCEL-SEQ
DRAFT-SOURCE
APP-SEQ
DTXSET2 CR-COMPANY
CR-TYPE
CR-NBR
CR-BATCH
CR-PYMNT-SEQ
CR-APP-SEQ
DTCREDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Required
DTX-CR-COMPANY -> ARA-COMPANY (ARASET1)
DTX-CR-TYPE -> ARA-TRANS-TYPE
DTX-CR-NBR -> ARA-INVOICE
DTX-CR-PYMNT-SEQ -> ARA-PAYMENT-SEQ
DTX-CR-BATCH -> ARA-BATCH-NBR
DTX-CR-APP-SEQ -> ARA-APP-SEQ
Ardrafts ARDRAFTS Required
DTX-COMPANY -> ARD-COMPANY
DTX-AR-DRAFT-NBR -> ARD-AR-DRAFT-NBR
DTX-SUFFIX -> ARD-SUFFIX
DTX-CUSTOMER -> ARD-CUSTOMER
DTX-CANCEL-SEQ -> ARD-CANCEL-SEQ
DTX-DRAFT-SOURCE -> ARD-DRAFT-SOURCE
Aroitems AROITEMS Required
DTX-CR-COMPANY -> ARO-COMPANY
DTX-CR-TYPE -> ARO-TRANS-TYPE
DTX-CR-NBR -> ARO-INVOICE
DTX-CR-PYMNT-SEQ -> ARO-PAYMENT-SEQ
|
