APDRFTDIST FILE
Bill of Exchange Distribution
The Bill of Exchange Distribution file contains distribution records
associated with a bill of exchange payment.
REFERENCED BY
AP195 AP260
UPDATED BY
AP125 AP126 AP151 AP180 AP181 AP185
AP25.1 AP25.2 AP26.1 AP28.1 AP28.2 AP305
AP56.1 AP954 AP984 CB300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDT-COMPANY Numeric 4 AP125 AP126
Company The company associated with the bill of AP151 AP180
exchange. Must be a valid record in the AP181 AP25.1
Accounts Payable Company file. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-BANK-INST-CODE Alpha 3 AP125 AP126
Payment Code The payment code assigned to the bill AP151 AP180
of exchange. Represents the type of bill AP181 AP25.1
of exchange payment. Must be a valid AP25.2 AP26.1
bill of exchange payment transaction AP28.1 AP28.2
code in the Bank Transaction Code file. AP56.1 AP954
DDT-TRANS-IDENT Numeric 10 AP125 AP126
Transaction ID A unique system-generated AP151 AP180
identification value assigned to the AP181 AP25.1
transaction to make the record unique. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-SEQ-NBR Numeric 4 AP125 AP126
Sequence Number A unique sequence number assigned to AP151 AP180
the distribution record. AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-PAY-GROUP Alpha 4 AP125 AP126
Pay Group The pay group associated with the bill AP151 AP180
of exchange. A pay group is used for AP181 AP25.1
processing accounts payable payments. AP25.2 AP26.1
Must be a valid record in the Pay Group AP28.1 AP28.2
file. AP56.1 AP954
DDT-DIST-TYPE Alpha 1 AP125 AP126
Distribution Type The distribution type. Valid values AP151 AP180
are: AP181 AP25.1
AP25.2 AP26.1
D = Distribution. AP28.1 AP28.2
I = Intercompany Distribution. AP56.1 AP954
G = Gain or Loss Distribution.
A = Accepted.
C = Cashed.
X = Canceled.
R = Tax Reversal.
DDT-VENDOR Alpha 9 AP125 AP126
Vendor ID The payment vendor number. Must be a AP151 AP180
valid record in the Vendor file. AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-TRANS-NBR Alpha 10 (Right Justified) AP125 AP126
Bill of Exchange The bill of exchange number. AP151 AP180
Number AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-SUFFIX Numeric 3 AP125 AP126
Bill of Exchange The bill of exchange suffix number. AP151 AP180
Suffix AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-REC-STATUS Numeric 1 AP125 AP126
Bill of Exchange The status of the bill of exchange AP151 AP180
Status distribution. Valid values are: AP181 AP185
AP25.1 AP25.2
1 = Unposted. AP26.1 AP28.1
9 = Posted. AP28.2 AP56.1
AP954
DDT-INV-VENDOR Alpha 9 AP125 AP126
Invoice Vendor The invoiced vendor number. Must be a AP151 AP180
valid record in the Vendor file. AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-INVOICE Alpha 22 AP125 AP126
Invoice Number The invoice number applied to the bill AP151 AP180
of exchange payment. Must be a valid AP181 AP25.1
record in the Accounts Payable Invoice AP25.2 AP26.1
file. AP28.1 AP28.2
AP56.1 AP954
DDT-INV-SUFFIX Numeric 3 AP125 AP126
Invoice Suffix The invoice suffix number applied to AP151 AP180
the bill of exchange payment. AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-INV-CANCEL-SEQ Numeric 4 AP125 AP126
Invoice Cancel The sequence number assigned upon the AP151 AP180
Sequence cancellation of a distributed bill of AP181 AP25.1
exchange payment. The first sequence AP25.2 AP26.1
assigned is 9999. AP28.1 AP28.2
AP56.1 AP954
DDT-INV-SEQ-NBR Numeric 4 AP125 AP126
Invoice Sequence The sequence number assigned to a bill AP151 AP25.1
of exchange payment application. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-INV-VOID-SEQ Numeric 4 AP125 AP126
Invoice Void The sequence number assigned upon the AP151 AP25.1
Sequence voiding of a distributed bill of AP25.2 AP26.1
exchange payment. AP28.1 AP28.2
AP56.1 AP954
DDT-TRAN-DIST-AMT Signed 15.2 AP125 AP126
Distribution Amount The amount of the bill of exchange AP151 AP180
distribution in the currency of the bill AP181 AP25.1
of exchange. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-BASE-DIST-AMT Signed 15.2 AP125 AP126
Base Currency The amount of the bill of exchange AP151 AP180
Distribution Amt distribution in the company base AP181 AP25.1
currency. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-TO-BASE-AMT Signed 15.2 AP125 AP126
To Cpy Base The amount of the bill of exchange AP151 AP180
Distribution Amt distribution in the distribution company AP181 AP25.1
base currency. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-TRAN-ND Numeric 1 AP125 AP126
Transaction Number The number of decimal positions defined AP151 AP180
of Decimals for the bill of exchange currency. AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-BASE-ND Numeric 1 AP125 AP126
Base Currency Nbr The number of decimals defined for the AP151 AP180
of Decimals company base currency. AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-CURRENCY-CODE Alpha 5 AP125 AP126
Bill of Exchange The bill of exchange currency. Must be AP151 AP180
Currency a valid record in the Currency Code AP181 AP25.1
file. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-ACCR-CODE Alpha 4 AP125 AP126
Invoice Accrual Code The invoice accrual code associated AP151 AP180
with the bill of exchange payment AP181 AP25.1
distribution. Used to default a general AP25.2 AP26.1
ledger accrual account to an invoice. AP28.1 AP28.2
Must be a valid record in the Invoice AP56.1 AP954
Accrual Code file.
DDT-ORIG-COMPANY Numeric 4 AP125 AP126
Originating Company The company associated with the bill of AP151 AP180
exchange. Must be a valid record in the AP181 AP25.1
Accounts Payable Company file. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-DIST-COMPANY Numeric 4 AP125 AP126
Distribution Company The company used for posting the bill AP151 AP180
of exchange distribution. Must be a AP181 AP25.1
valid record in the General Ledger AP25.2 AP26.1
Company file and a valid relationship AP28.1 AP28.2
must exist in the Intercompany AP56.1 AP954
Relationship file.
DDT-DST-ACCT-UNIT Alpha 15 AP125 AP126
Distribution The general ledger distribution AP151 AP180
Accounting Unit accounting unit assigned to the bill of AP181 AP25.1
exchange distribution. Must be a valid AP25.2 AP26.1
accounting unit in the Lawson General AP28.1 AP28.2
Ledger system. AP56.1 AP954
DDT-DST-ACCOUNT Numeric 6 AP125 AP126
Distribution The general ledger distribution account AP151 AP180
Account Number number assigned to the bill of exchange AP181 AP25.1
distribution. Must be a valid account in AP25.2 AP26.1
the Lawson General Ledger system. AP28.1 AP28.2
AP56.1 AP954
DDT-DST-SUB-ACCT Numeric 4 AP125 AP126
Distribution The general ledger distribution AP151 AP180
Subaccount Number subaccount number assigned to the bill AP181 AP25.1
of exchange distribution. Must be a AP25.2 AP26.1
valid subaccount in the Lawson General AP28.1 AP28.2
Ledger system. AP56.1 AP954
DDT-DRAFT-CODE Alpha 4 AP125 AP126
Bill of Exchange The bill of exchange accrual code AP151 AP180
Accrual Code associated with the bill of exchange AP181 AP25.1
payment. Used to default an acceptance AP25.2 AP26.1
account to the bill of exchange. Must be AP28.1 AP28.2
a valid record in the Bill of Exchange AP56.1 AP954
Accrual Code file.
DDT-POST-DATE Numeric 8 (yyyymmdd) AP125 AP126
Post Date The date used for posting the cashed or AP151 AP180
dishonored bill of exchange payment AP181 AP25.1
distribution to the general ledger. AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
DDT-GLT-OBJ-ID Numeric 12 AP185 AP954
Subsystem GL This is a subsystem GL interface AP984
Interface ID identification number. It is used for
Drill Around purposes.
DDT-JRNL-BOOK-NBR Alpha 12 AP125 AP126
Journal Book The journal book assigned to the AP151 AP180
transaction. AP181 AP25.1
AP25.2 AP26.1
AP28.1 AP28.2
AP56.1 AP954
APDRFTDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DDTSET1 BANK-INST-CODEThis index is used to group all general AP125 AP126
TRANS-IDENT ledger distributions for a specific bill AP151 AP180
SEQ-NBR of exchange payment. AP181 AP185
AP195 AP25.1
AP25.2 AP26.1
AP260 AP28.1
AP28.2 AP305
AP56.1 AP984
CB300
DDTSET2 DIST-COMPANY This index is used to sort all bill of
DST-ACCT-UNIT exchange payment records by general
DST-ACCOUNT ledger account number.
DST-SUB-ACCT KeyChange
POST-DATE
GLT-OBJ-ID
BANK-INST-CODE
TRANS-IDENT
SEQ-NBR
APDRFTDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompanydist APCOMPANY Required
DDT-DIST-COMPANY -> CPY-COMPANY (CPYSET1)
Apcompanyorig APCOMPANY Required
DDT-ORIG-COMPANY -> CPY-COMPANY
Apdrafts APDRAFTS Required
DDT-BANK-INST-CODE -> APT-BANK-INST-CODE
DDT-TRANS-IDENT -> APT-TRANS-IDENT
Appayment APPAYMENT Not Required
Valid When DDT-INVOICE != Spaces
DDT-DIST-COMPANY -> APP-COMPANY
DDT-INV-VENDOR -> APP-VENDOR
DDT-INVOICE -> APP-INVOICE
DDT-INV-SUFFIX -> APP-SUFFIX
DDT-INV-CANCEL-SEQ -> APP-CANCEL-SEQ
DDT-INV-SEQ-NBR -> APP-SEQ-NBR
DDT-INV-VOID-SEQ -> APP-VOID-SEQ
Apvenmast APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
DDT-VENDOR -> VEN-VENDOR
Glmaster GLMASTER Required
DDT-DIST-COMPANY -> GLM-COMPANY
DDT-DST-ACCT-UNIT -> GLM-ACCT-UNIT
DDT-DST-ACCOUNT -> GLM-ACCOUNT
DDT-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Glsystem Orig GLSYSTEM Required
DDT-ORIG-COMPANY -> GLS-COMPANY
Glsystem To GLSYSTEM Required
DDT-DIST-COMPANY -> GLS-COMPANY
|