Bill of Exchange Distribution
The Bill of Exchange Distribution file contains distribution records associated with a bill of exchange payment.
REFERENCED BY
AP136 | AP232 |
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 | AP195 |
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
DDT-TRANS-IDENT Element: Transaction ID | Numeric 10 A unique system-generated identification value assigned to the transaction to make the record unique. |
|
||||||||||||||||
DDT-SEQ-NBR Element: Seq Nbr | Numeric 4 A unique sequence number assigned to the distribution record. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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 |
|
||||||||||||||||
DDT-VENDOR Element: Vendor | Alpha 9 (Right Justified) The payment vendor number. Must be a valid record in the Vendor file. |
|
||||||||||||||||
DDT-TRANS-NBR Bill of Exchange Number | Alpha 10 (Right Justified) The bill of exchange number. |
|
||||||||||||||||
DDT-SUFFIX Bill of Exchange Suffix | Numeric 3 The bill of exchange suffix number. |
|
||||||||||||||||
DDT-REC-STATUS Bill of Exchange Status | Numeric 1 The status of the bill of exchange distribution. Valid values are: 1 = Unposted. 9 = Posted. |
|
||||||||||||||||
DDT-INV-VENDOR Element: Vendor | Alpha 9 (Right Justified) The invoiced vendor number. Must be a valid record in the Vendor file. |
|
||||||||||||||||
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. |
|
||||||||||||||||
DDT-INV-SUFFIX Element: Invoice Suffix | Numeric 3 The invoice suffix number applied to the bill of exchange payment. |
|
||||||||||||||||
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. |
|
||||||||||||||||
DDT-INV-SEQ-NBR Element: Invoice Sequence | Numeric 4 The sequence number assigned to a bill of exchange payment application. |
|
||||||||||||||||
DDT-INV-VOID-SEQ Invoice Void Sequence | Numeric 4 The sequence number assigned upon the voiding of a distributed bill of exchange payment. |
|
||||||||||||||||
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. |
|
||||||||||||||||
DDT-BASE-DIST-AMT Base Currency Distribution Amt | Signed 18.2 The amount of the bill of exchange distribution in the company base currency. |
|
||||||||||||||||
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. |
|
||||||||||||||||
DDT-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the bill of exchange currency. |
|
||||||||||||||||
DDT-BASE-ND Base Currency Nbr of Decimals | Numeric 1 The number of decimals defined for the company base currency. |
|
||||||||||||||||
DDT-CURRENCY-CODE Bill of Exchange Currency | Alpha 5 The bill of exchange currency. Must be a valid record in the Currency Code file. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
DDT-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DDTSET1 |
BANK-INST-CODE TRANS-IDENT SEQ-NBR |
|
| ||||||||||||||||||||||||||
DDTSET2 |
DIST-COMPANY DST-ACCT-UNIT DST-ACCOUNT DST-SUB-ACCT POST-DATE GLT-OBJ-ID BANK-INST-CODE TRANS-IDENT SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apapphist | APAPPHIST |
Not Required
| |||||||||||||||||||||||||||
Apcompanydist | APCOMPANY |
Required
| |||||||||||||||||||||||||||
Apcompanyorig | APCOMPANY |
Required
| |||||||||||||||||||||||||||
Apdrafts | APDRAFTS |
Required
| |||||||||||||||||||||||||||
Appayment | APPAYMENT |
Not Required
| |||||||||||||||||||||||||||
Apvenmast | APVENMAST |
Not Required
| |||||||||||||||||||||||||||
Glmaster | GLMASTER |
Required
| |||||||||||||||||||||||||||
Glsystem Orig | GLSYSTEM |
Required
| |||||||||||||||||||||||||||
Glsystem To | GLSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.