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
AP136 AP195
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: Seq Nbr A 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: Dist Type The 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 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 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 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. 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
Element: Acct Nd The number of decimal positions defined AP151 AP180
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: Acct Unit The 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
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
DDT-JRNL-BOOK-NBR Alpha 12 AP125 AP126
Element: Jrnl Book Nbr 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-CODE AP125 AP126
TRANS-IDENT AP136 AP151
SEQ-NBR AP180 AP181
AP185 AP195
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP305 AP56.1
CB300 MA61.1
MAI1.1
DDTSET2 DIST-COMPANY KeyChange AP180 AP181
DST-ACCT-UNIT AP28.1 AP28.2
DST-ACCOUNT
DST-SUB-ACCT
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
|