Lawson Insight Technical Documentation |
|
APDRFTDIST
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 AP27.1 AP28.1 AP28.2
AP305 AP56.1 CB300 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDT-COMPANY Numeric 4 AP125 AP126
Element: 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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-BANK-INST-CODE Alpha 3 AP125 AP126
Element: 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 AP27.1 AP28.1
code in the Bank Transaction Code file. AP28.2 AP56.1
MA61.1 MAI1.1
DDT-TRANS-IDENT Numeric 10 AP125 AP126
Element: Transaction IDA unique system-generated AP151 AP180
identification value assigned to the AP181 AP25.1
transaction to make the record unique. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-SEQ-NBR Numeric 4 AP125 AP126
Element: Sequence NumbeA unique sequence number assigned to AP151 AP180
the distribution record. AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-PAY-GROUP Alpha 4 AP125 AP126
Element: 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 AP27.1 AP28.1
file. AP28.2 AP56.1
MA61.1 MAI1.1
DDT-DIST-TYPE Alpha 1 AP125 AP126
Element: Distribution TThe distribution type. Valid values are: AP151 AP180
AP181 AP25.1
D = Distribution. AP25.2 AP26.1
I = Intercompany Distribution. AP27.1 AP28.1
G = Gain/Loss Distribution. AP28.2 AP56.1
A = Accepted MA61.1 MAI1.1
C = Cashed
X = Canceled
R = Tax Reversal
DDT-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The payment vendor number. Must be a AP151 AP180
valid record in the Vendor file. AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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 AP27.1
9 = Posted. AP28.1 AP28.2
AP56.1 MA61.1
MAI1.1
DDT-INV-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The invoiced vendor number. Must be a AP151 AP180
valid record in the Vendor file. AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-INVOICE Alpha 22 AP125 AP126
Element: Invoice NumberThe 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. AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-INV-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThe invoice suffix number applied to AP151 AP180
the bill of exchange payment. AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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. AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-INV-SEQ-NBR Numeric 4 AP125 AP126
Element: Invoice SequenThe sequence number assigned to a bill AP151 AP25.1
of exchange payment application. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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. AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-TRAN-DIST-AMT Signed 18.2 AP125 AP126
Element: Intl Amt 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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-BASE-DIST-AMT Signed 18.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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-TO-BASE-AMT Signed 18.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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-TRAN-ND Numeric 1 AP125 AP126
Account Currency The number of decimal positions defined AP151 AP180
Code for the bill of exchange currency. AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-ACCR-CODE Alpha 4 AP125 AP126
Element: Invoice AccruaThe 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. AP27.1 AP28.1
Must be a valid record in the Invoice AP28.2 AP56.1
Accrual Code file. MA61.1 MAI1.1
DDT-ORIG-COMPANY Numeric 4 AP125 AP126
Element: Originating CoThe 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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-DIST-COMPANY Numeric 4 AP125 AP126
Element: 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 AP27.1 AP28.1
must exist in the Intercompany AP28.2 AP56.1
Relationship file. MA61.1 MAI1.1
DDT-DST-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThe general ledger distribution AP151 AP180
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 AP27.1 AP28.1
Ledger system. AP28.2 AP56.1
MA61.1 MAI1.1
DDT-DST-ACCOUNT Numeric 6 AP125 AP126
Element: Account The general ledger distribution account AP151 AP180
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. AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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 AP27.1 AP28.1
Ledger system. AP28.2 AP56.1
MA61.1 MAI1.1
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 AP27.1 AP28.1
a valid record in the Bill of Exchange AP28.2 AP56.1
Accrual Code file. MA61.1 MAI1.1
DDT-POST-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: 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
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
DDT-GLT-OBJ-ID Numeric 12 AP185
Object This is a subsystem GL interface
Identification identification number. It is used for
Drill Around purposes.
DDT-JRNL-BOOK-NBR Alpha 12 AP125 AP126
Element: Journal Book The journal book assigned to the AP151 AP180
transaction. AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MA61.1 MAI1.1
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 AP27.1
AP28.1 AP28.2
AP305 AP56.1
CB300 MA61.1
MAI1.1
DDTSET2 DIST-COMPANY This index is used to sort all bill of AP180 AP181
DST-ACCT-UNIT exchange payment records by general AP28.1 AP28.2
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
Apapphist APAPPHIST Not Required
Valid When DDT-INVOICE != Spaces
DDT-DIST-COMPANY -> AH3-COMPANY
DDT-INV-VENDOR -> AH3-VENDOR
DDT-INVOICE -> AH3-INVOICE
DDT-INV-SUFFIX -> AH3-SUFFIX
DDT-INV-CANCEL-SEQ -> AH3-CANCEL-SEQ
DDT-INV-SEQ-NBR -> AH3-SEQ-NBR
DDT-INV-VOID-SEQ -> AH3-VOID-SEQ
Apcompanydist APCOMPANY Required
DDT-DIST-COMPANY -> CPY-COMPANY
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
|