Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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

AP195     AP260

UPDATED BY

AP125     AP126     AP151     AP180     AP181     AP185
AP25.1    AP25.2    AP26.1    AP27.1    AP28.1    AP28.2
AP305     AP56.1    API1.1    CB300     MA41.7    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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-SEQ-NBR            Numeric 4                                 AP125   AP126
Element: Sequence NumbeA 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-DIST-TYPE          Alpha 1                                   AP125   AP126
Element: Distribution TThe 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                              API1.1  MA41.7
                       C = Cashed                                MA61.1  MAI1.1
                       X = Canceled
                       R = Tax Reversal

DDT-VENDOR             Alpha 9  (Right Justified)                AP125   AP126
Element: Vendor ID     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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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  API1.1
                                                                 MA41.7  MA61.1
                                                                 MAI1.1

DDT-INV-VENDOR         Alpha 9  (Right Justified)                AP125   AP126
Element: Vendor ID     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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-INVOICE            Alpha 22                                  AP125   AP126
Element: Invoice NumberThe 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-TRAN-DIST-AMT      Signed 15.2                               AP125   AP126
Element: Adj 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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-BASE-DIST-AMT      Signed 15.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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-TO-BASE-AMT        Signed 15.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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-TRAN-ND            Numeric 1                                 AP125   AP126
Account Currency       The number of decimal positions defined   AP151   AP180
Code                   for the bill of exchange currency.        AP181   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP56.1
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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.                        API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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.                        API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-DST-ACCT-UNIT      Alpha 15                                  AP125   AP126
Element: Accounting UniThe 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 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.                        API1.1  MA41.7
                                                                 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
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

DDT-GLT-OBJ-ID         Numeric 12                                AP185
Object
Identification

DDT-JRNL-BOOK-NBR      Alpha 12                                  AP125   AP126
Element: Journal Book  The journal book assigned to the          AP151   AP180
                       transaction.                              AP181   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP56.1
                                                                 API1.1  MA41.7
                                                                 MA61.1  MAI1.1

                         APDRFTDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DDTSET1   BANK-INST-CODEThis index is used to group all general  AP125   AP126
          TRANS-IDENT   ledger distributions for a specific bill AP151   AP180
          SEQ-NBR       of exchange payment.                     AP181   AP185
                                                                 AP195   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP260   AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP305   AP56.1
                                                                 API1.1  CB300
                                                                 MA41.7  MA61.1
                                                                 MAI1.1

DDTSET2   DIST-COMPANY  This index is used to sort all bill of   AP180   AP181
          DST-ACCT-UNIT exchange payment records by general      AP28.1  AP28.2
          DST-ACCOUNT   ledger account number.
          DST-SUB-ACCT  KeyChange
          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