APDRFTDIST

Bill of Exchange Distribution

The Bill of Exchange Distribution file contains distribution records associated with a bill of exchange payment.

REFERENCED BY
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 MAI1.1 AP136

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDT-COMPANY
Element: Company		Numeric 4
The company associated with the bill of exchange. Must be a valid record in the Accounts Payable Company file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-BANK-INST-CODE
Element: Payment Code		Alpha 3
The payment code assigned to the bill of exchange. Represents the type of bill of exchange payment. Must be a valid bill of exchange payment transaction code in the Bank Transaction Code file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-TRANS-IDENT
Element: Transaction ID		Numeric 10
A unique system-generated identification value assigned to the transaction to make the record unique.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-SEQ-NBR
Element: Seq Nbr		Numeric 4
A unique sequence number assigned to the distribution record.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-PAY-GROUP
Element: Pay Group		Alpha 4
The pay group associated with the bill of exchange. A pay group is used for processing accounts payable payments. Must be a valid record in the Pay Group file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-DIST-TYPE
Element: Dist Type		Alpha 1
The distribution type. Valid values are: D = Distribution. I = Intercompany Distribution. G = Gain/Loss Distribution.
A = Accepted
C = Cashed
X = Canceled
R = Tax Reversal
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The payment vendor number. Must be a valid record in the Vendor file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-TRANS-NBR
Bill of Exchange
Number		Alpha 10 (Right Justified)
The bill of exchange number.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-SUFFIX
Bill of Exchange
Suffix		Numeric 3
The bill of exchange suffix number.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-REC-STATUS
Bill of Exchange
Status		Numeric 1
The status of the bill of exchange distribution. Valid values are: 1 = Unposted. 9 = Posted.
AP125 AP126
AP151 AP180
AP181 AP185
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP56.1 MAI1.1
DDT-INV-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The invoiced vendor number. Must be a valid record in the Vendor file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-INVOICE
Element: Invoice		Alpha 22
The invoice number applied to the bill of exchange payment. Must be a valid record in the Accounts Payable Invoice file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-INV-SUFFIX
Element: Invoice Suffix		Numeric 3
The invoice suffix number applied to the bill of exchange payment.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-INV-CANCEL-SEQ
Invoice Cancel
Sequence		Numeric 4
The sequence number assigned upon the cancellation of a distributed bill of exchange payment. The first sequence assigned is 9999.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-INV-SEQ-NBR
Element: Invoice Sequence		Numeric 4
The sequence number assigned to a bill of exchange payment application.
AP125 AP126
AP151 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-INV-VOID-SEQ
Invoice Void
Sequence		Numeric 4
The sequence number assigned upon the voiding of a distributed bill of exchange payment.
AP125 AP126
AP151 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-TRAN-DIST-AMT
Element: Intl Amt		Signed 18.2
The amount of the bill of exchange distribution in the currency of the bill of exchange.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-BASE-DIST-AMT
Base Currency
Distribution Amt		Signed 18.2
The amount of the bill of exchange distribution in the company base currency.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-TO-BASE-AMT
To Cpy Base
Distribution Amt		Signed 18.2
The amount of the bill of exchange distribution in the distribution company base currency.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-TRAN-ND
Element: Acct Nd		Numeric 1
The number of decimal positions defined for the bill of exchange currency.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-BASE-ND
Base Currency Nbr
of Decimals		Numeric 1
The number of decimals defined for the company base currency.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-CURRENCY-CODE
Bill of Exchange
Currency		Alpha 5
The bill of exchange currency. Must be a valid record in the Currency Code file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-ACCR-CODE
Element: Invoice Accrual Code		Alpha 4
The invoice accrual code associated with the bill of exchange payment distribution. Used to default a general ledger accrual account to an invoice. Must be a valid record in the Invoice Accrual Code file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-ORIG-COMPANY
Element: Originating Company		Numeric 4
The company associated with the bill of exchange. Must be a valid record in the Accounts Payable Company file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-DIST-COMPANY
Element: Company		Numeric 4
The company used for posting the bill of exchange distribution. Must be a valid record in the General Ledger Company file and a valid relationship must exist in the Intercompany Relationship file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-DST-ACCT-UNIT
Element: Acct Unit		Alpha 15
The general ledger distribution accounting unit assigned to the bill of exchange distribution. Must be a valid accounting unit in the Lawson General Ledger system.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-DST-ACCOUNT
Element: Account		Numeric 6
The general ledger distribution account number assigned to the bill of exchange distribution. Must be a valid account in the Lawson General Ledger system.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-DST-SUB-ACCT
Distribution
Subaccount Number		Numeric 4
The general ledger distribution subaccount number assigned to the bill of exchange distribution. Must be a valid subaccount in the Lawson General Ledger system.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-DRAFT-CODE
Bill of Exchange
Accrual Code		Alpha 4
The bill of exchange accrual code associated with the bill of exchange payment. Used to default an acceptance account to the bill of exchange. Must be a valid record in the Bill of Exchange Accrual Code file.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-POST-DATE
Element: Post Date		Numeric 8 (yyyymmdd)
The date used for posting the cashed or dishonored bill of exchange payment distribution to the general ledger.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1
DDT-GLT-OBJ-ID
Element: Obj Id		Numeric 12
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.
AP185
DDT-JRNL-BOOK-NBR
Element: Jrnl Book Nbr		Alpha 12
The journal book assigned to the transaction.
AP125 AP126
AP151 AP180
AP181 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP56.1
MAI1.1


APDRFTDIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DDTSET1 BANK-INST-CODE
TRANS-IDENT
SEQ-NBR
AP125 AP126
AP136 AP151
AP180 AP181
AP185 AP195
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP305 AP56.1
CB300 MAI1.1
DDTSET2 DIST-COMPANY
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
POST-DATE
GLT-OBJ-ID
BANK-INST-CODE
TRANS-IDENT
SEQ-NBR
KeyChange
AP180 AP181
AP28.1 AP28.2


APDRFTDIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:47:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.