APDRFTDIST – Bill of Exchange Distribution

System
Accounts Payable (AP)
Prefix
DDT
Primary key
BANK-INST-CODE, TRANS-IDENT, SEQ-NBR
Fields
32
Updated by
18 programs
Referenced by
2 programs

APDRFTDIST is the Bill of Exchange Distribution table in Lawson Accounts Payable (prefix DDT). It is indexed by BANK-INST-CODE, TRANS-IDENT, SEQ-NBR (DDTSET1); alternate indexes: DDTSET2. It is related 1:1 to APAPPHIST, APCOMPANY, APDRAFTS, APPAYMENT, APVENMAST, GLMASTER and GLSYSTEM. It is updated by AP125, AP126, AP151, AP180, AP181, AP185, AP195, AP25.1 and 10 more and referenced by AP136 and AP232. The table has 32 fields, 2 indexes and 9 documented relations.

About APDRFTDIST

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

Fields (32)

Column = COBOL field name without the DDT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#DDT-COMPANY
COMPANY		Numeric 4The 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 +6 more
#DDT-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3The 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 +6 more
#DDT-TRANS-IDENT PK
TRANS_IDENT		Numeric 10A 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 +6 more
#DDT-SEQ-NBR PK
SEQ_NBR		Numeric 4A unique sequence number assigned to the distribution record.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-PAY-GROUP
PAY_GROUP		Alpha 4The 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 +6 more
#DDT-DIST-TYPE
DIST_TYPE		Alpha 1The 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 +6 more
#DDT-VENDOR
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 +6 more
#DDT-TRANS-NBR
TRANS_NBR		Alpha 10 (Right Justified)The bill of exchange number.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-SUFFIX
SUFFIX		Numeric 3The bill of exchange suffix number.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-REC-STATUS
REC_STATUS		Numeric 1The status of the bill of exchange distribution. Valid values are:
  • 1 Unposted.
  • 9 Posted.
AP125, AP126, AP151, AP180, AP181, AP185, AP25.1, AP25.2 +7 more
#DDT-INV-VENDOR
INV_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 +6 more
#DDT-INVOICE
INVOICE		Alpha 22The 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 +6 more
#DDT-INV-SUFFIX
INV_SUFFIX		Numeric 3The invoice suffix number applied to the bill of exchange payment.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-INV-CANCEL-SEQ
INV_CANCEL_SEQ		Numeric 4The 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 +6 more
#DDT-INV-SEQ-NBR
INV_SEQ_NBR		Numeric 4The sequence number assigned to a bill of exchange payment application.AP125, AP126, AP151, AP25.1, AP25.2, AP26.1, AP27.1, AP28.1 +4 more
#DDT-INV-VOID-SEQ
INV_VOID_SEQ		Numeric 4The 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 +4 more
#DDT-TRAN-DIST-AMT
TRAN_DIST_AMT		Signed 18.2The 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 +6 more
#DDT-BASE-DIST-AMT
BASE_DIST_AMT		Signed 18.2The amount of the bill of exchange distribution in the company base currency.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-TO-BASE-AMT
TO_BASE_AMT		Signed 18.2The amount of the bill of exchange distribution in the distribution company base currency.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-TRAN-ND
TRAN_ND		Numeric 1The number of decimal positions defined for the bill of exchange currency.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-BASE-ND
BASE_ND		Numeric 1The number of decimals defined for the company base currency.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more
#DDT-CURRENCY-CODE
CURRENCY_CODE		Alpha 5The 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 +6 more
#DDT-ACCR-CODE
ACCR_CODE		Alpha 4The 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 +6 more
#DDT-ORIG-COMPANY
ORIG_COMPANY		Numeric 4The 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 +6 more
#DDT-DIST-COMPANY SET2
DIST_COMPANY		Numeric 4The 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 +6 more
#DDT-DST-ACCT-UNIT SET2
DST_ACCT_UNIT		Alpha 15The 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 +6 more
#DDT-DST-ACCOUNT SET2
DST_ACCOUNT		Numeric 6The 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 +6 more
#DDT-DST-SUB-ACCT SET2
DST_SUB_ACCT		Numeric 4The 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 +6 more
#DDT-DRAFT-CODE
DRAFT_CODE		Alpha 4The 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 +6 more
#DDT-POST-DATE SET2
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 +6 more
#DDT-GLT-OBJ-ID SET2
GLT_OBJ_ID		Numeric 12This 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
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.AP125, AP126, AP151, AP180, AP181, AP25.1, AP25.2, AP26.1 +6 more

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DDTSET1
  1. BANK-INST-CODE
  2. TRANS-IDENT
  3. SEQ-NBR
PrimaryAP125, AP126, AP136, AP151, AP180, AP181, AP185, AP195 +12 more
DDTSET2
  1. DIST-COMPANY
  2. DST-ACCT-UNIT
  3. DST-ACCOUNT
  4. DST-SUB-ACCT
  5. POST-DATE
  6. GLT-OBJ-ID
  7. BANK-INST-CODE
  8. TRANS-IDENT
  9. SEQ-NBR
KeyChangeAP180, AP181, AP28.1, AP28.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APAPPHISTAPCOMPANYAPDRAFTSAPPAYMENTAPVENMASTGLMASTERGLSYSTEMAPDRFTDIST

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApapphistAPAPPHISTNot RequiredValid 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
ApcompanydistAPCOMPANYRequired
DDT-DIST-COMPANY→CPY-COMPANY
ApcompanyorigAPCOMPANYRequired
DDT-ORIG-COMPANY→CPY-COMPANY
ApdraftsAPDRAFTSRequired
DDT-BANK-INST-CODE→APT-BANK-INST-CODE
DDT-TRANS-IDENT→APT-TRANS-IDENT
AppaymentAPPAYMENTNot RequiredValid 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
ApvenmastAPVENMASTNot Required
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
DDT-VENDOR→VEN-VENDOR
GlmasterGLMASTERRequired
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 OrigGLSYSTEMRequired
DDT-ORIG-COMPANY→GLS-COMPANY
Glsystem ToGLSYSTEMRequired
DDT-DIST-COMPANY→GLS-COMPANY

Programs

Updated by (18)

Referenced by (2)