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.

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
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
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
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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DDTSET1BANK-INST-CODE, TRANS-IDENT, SEQ-NBRPrimaryAP125, AP126, AP136, AP151, AP180, AP181, AP185, AP195 +12 more
DDTSET2DIST-COMPANY, DST-ACCT-UNIT, DST-ACCOUNT, DST-SUB-ACCT, POST-DATE, GLT-OBJ-ID, BANK-INST-CODE, TRANS-IDENT, SEQ-NBRKeyChangeAP180, AP181, AP28.1, AP28.2

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApapphistAPAPPHISTNot RequiredValid When DDT-INVOICE != SpacesDDT-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
ApcompanydistAPCOMPANYRequiredDDT-DIST-COMPANY → CPY-COMPANY
ApcompanyorigAPCOMPANYRequiredDDT-ORIG-COMPANY → CPY-COMPANY
ApdraftsAPDRAFTSRequiredDDT-BANK-INST-CODE → APT-BANK-INST-CODE, DDT-TRANS-IDENT → APT-TRANS-IDENT
AppaymentAPPAYMENTNot RequiredValid When DDT-INVOICE != SpacesDDT-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 RequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, DDT-VENDOR → VEN-VENDOR
GlmasterGLMASTERRequiredDDT-DIST-COMPANY → GLM-COMPANY, DDT-DST-ACCT-UNIT → GLM-ACCT-UNIT, DDT-DST-ACCOUNT → GLM-ACCOUNT, DDT-DST-SUB-ACCT → GLM-SUB-ACCOUNT
Glsystem OrigGLSYSTEMRequiredDDT-ORIG-COMPANY → GLS-COMPANY
Glsystem ToGLSYSTEMRequiredDDT-DIST-COMPANY → GLS-COMPANY

Programs

Updated by (18)

Referenced by (2)