DTCREDIT FILE Bill of Exchange Credit file. REFERENCED BY AR37.8 DT170 DT180 DT181 DT92.1 UPDATED BY AR44.3 DT150 DT40.1 DT45.1 DT520 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY DTX-COMPANY Numeric 4 AR44.3 DT150 Company The company number represents an DT40.1 DT520 established company and is entered on all function codes. DTX-DRAFT-NBR Alpha 10 (Right Justified) AR44.3 DT150 Bill of Exchange Bill of exchange number. DT40.1 DT520 Number DTX-SUFFIX Numeric 3 AR44.3 DT150 Invoice Suffix This is the suffix for the invoice. DT40.1 DT520 DTX-CUSTOMER Alpha 9 (Right Justified) AR44.3 DT150 Customer Number This field contains the number that DT40.1 DT520 represents a customer. DTX-CANCEL-SEQ Numeric 4 AR44.3 DT150 Cancel Sequence The sequence number assigned upon a DT40.1 DT45.1 cancellation of a distributed invoice. DT520 The first sequence assigned is 9999. DTX-DRAFT-SOURCE Alpha 1 AR44.3 DT150 Bill of Exchange This defines origination of the bill of DT40.1 DT520 Source exchange. DTX-APP-SEQ Numeric 5 AR44.3 DT150 App Seq Application sequence number. Used in the DT40.1 DT520 Accounts Receivable Application file. DTX-CR-COMPANY Numeric 4 AR44.3 DT150 Cr Company The company number associated with the DT40.1 DT520 payment or credit. DTX-CR-TYPE Alpha 1 AR44.3 DT150 Cr Type Transaction type of the payment or DT40.1 DT520 credit. DTX-CR-NBR Alpha 10 AR44.3 DT150 Credit Memo Number The transaction number of the payment or DT40.1 DT520 credit. DTX-CR-BATCH Numeric 6 AR44.3 DT150 Cr Batch The batch of the payment or credit. DT40.1 DT520 DTX-CR-PYMNT-SEQ Numeric 6 AR44.3 DT150 Cr Pymnt Seq Sequence number of the payment or DT40.1 DT520 credit. DTX-CR-CUSTOMER Alpha 9 (Right Justified) AR44.3 DT150 Cr Customer Customer number associated with the DT40.1 DT520 payment or credit. DTX-CR-APP-SEQ Numeric 5 AR44.3 DT150 Cr App Seq Sequence number of the application made DT40.1 DT520 with the payment or credit. DTCREDIT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN DTXSET1 COMPANY AR37.8 DT170 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-TRANS-NBR 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-DRAFT-NBR -> ARD-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-TRANS-NBR DTX-CR-PYMNT-SEQ -> ARO-PAYMENT-SEQ Dtapplied ARAPPLIED Not Required Valid When DTX-CR-TYPE != "C" DTX-COMPANY -> ARA-CR-COMPANY DTX-CUSTOMER -> ARA-CR-CUSTOMER "B" -> ARA-CR-TYPE DTX-DRAFT-NBR -> ARA-CR-NBR Zeroes -> ARA-CR-PYMNT-SEQ ARD-PMT-BATCH-NBR -> ARA-CR-BATCH DTX-SUFFIX -> ARA-CR-SUFFIX DTX-CANCEL-SEQ -> ARA-CR-CANCEL-SEQ DTX-APP-SEQ -> ARA-CR-APP-SEQ |