Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCDISTRIB


                            APCDISTRIB FILE

                         Distribution Interface

The Distribution Conversion file is used by the Invoice Interface program to
convert or interface invoice distribution records to the Lawson Accounts
Payable system. When you run AP520 (Invoice Interface), the system reads
records in this file for conversion or interface into the Invoice Distribution
file. When Distribution Interface records and associated Invoice Interface
records are successfully converted or interfaced, distribution interface
records are purged from this file. You can use AP52.3 (Distribution Interface)
to add  records to the interface file or maintain records already loaded into
the file before conversion or interface to the Lawson Accounts Payable system.

UPDATED BY

AP52.1    AP52.3    PR198     AP305     AP520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CVD-COMPANY            Numeric 4                                 AP52.3  PR198
Element: Company       Required. The company number. Must be a
                       valid record in the Accounts Payable
                       Company file.

CVD-VENDOR             Alpha 9  (Right Justified)                AP52.3  PR198
Element: Vendor ID     Required. The vendor number. Must be a
                       valid record in the Vendor file.

CVD-EDI-NBR            Alpha 15                                  AP52.3  PR198
Element: EDI Number    The electronic data interchange (EDI)
                       number assigned to the vendor.

CVD-INVOICE            Alpha 22                                  AP52.3  PR198
Element: Invoice NumberRequired. A unique invoice number for
                       the vendor.

CVD-SUFFIX             Numeric 3                                 AP52.3  PR198
Element: Invoice SuffixThe occurrence value of the invoice.
                       Not valid for invoices with an
                       unreleased status.

CVD-DIST-SEQ-NBR       Numeric 4                                 AP52.3  PR198
Element: Number of ItemRequired if you have more than one line
                       of distribution for an invoice. A unique
                       sequence number for the invoice
                       distribution. Valid values are 1 through
                       9999.

CVD-ORIG-TRAN-AMT      Signed 15.2                               AP52.3  PR198
Element: Adj Amt       Required. The amount of the invoice
                       distribution in the currency of the
                       invoice.

CVD-TAXABLE-AMT        Signed 15.2                               AP52.3  PR198
Element: Adj Amt       The taxable amount of the invoice
                       distribution.

CVD-DIST-COMPANY       Numeric 4                                 AP52.3  PR198
Element: Company       The company the invoice distribution
                       will be posted to. Must be a valid
                       record in the General Ledger Company
                       file. If different from the originating
                       company, a valid relationship must exist
                       in the General Ledger Intercompany file.
                       If left blank, the company number
                       defaults.

CVD-TO-BASE-AMT        Signed 15.2                               AP52.3  PR198
Element: Adj Amt       The amount of the distribution in the
                       base currency of the distribution
                       company. This field is required for
                       historical status invoices if the
                       Distribution Company is different from
                       the Company (an intercompany record).

CVD-DIS-ACCT-UNIT      Alpha 15                                  AP52.3  PR198
Element: Accounting UniRequired except for an unreleased
                       status distribution with a Tax Code. The
                       general ledger distribution accounting
                       unit. Must be a valid record in the
                       General Ledger Names file.

CVD-DIS-ACCOUNT        Numeric 6                                 AP52.3  PR198
Element: Account       Required except for an unreleased
                       status distribution with a Tax Code. The
                       general ledger distribution account
                       number. Must be a valid record in the
                       General Ledger Account Master file.

CVD-DIS-SUB-ACCT       Numeric 4                                 AP52.3  PR198
Element: Subaccount    If using subaccounts, this field is
                       required except for an unreleased status
                       distribution with a Tax Code. The
                       general ledger distribution subaccount
                       number. Must be a valid record in the
                       General Ledger Account Master file.

CVD-TAX-CODE           Alpha 10                                  AP52.3  PR198
Element: Tax Code      A tax code identifies the invoice
                       distribution as a tax distribution. The
                       tax code is user-defined and represents
                       tax information used in creating invoice
                       tax distribution records. Must be a
                       valid record in the Tax Code file.

CVD-DESCRIPTION        Alpha 30  (Lower Case)                    AP52.3  PR198
Element: Description   The distribution description. If left
                       blank, the vendor number and vendor name
                       defaults. This field accepts both upper
                       and lower case entries.

CVD-DST-REFERENCE      Alpha 10                                  AP52.3  PR198
Element: Cross Ref     The distribution reference. If left
                       blank, the default reference value
                       defined for the company defaults.

CVD-ACTIVITY           Alpha 15                                  AP52.3  PR198
Element: Activity      The activity assigned to the
                       distribution, if applicable. Used to
                       group expense distribution amounts to
                       track costs for projects, jobs,
                       construction, and so on. Must be a valid
                       record in the Lawson Activity Management
                       system. If blank, this value defaults
                       from the vendor, if assigned.

CVD-ASSET-DESC         Alpha 30  (Lower Case)                    AP52.3  PR198
Element: Asset DescriptIf the distribution contains asset
                       information, this field contains the
                       asset description.

CVD-TAG-NBR            Alpha 12                                  AP52.3  PR198
Element: Tag Number    If the distribution contains asset
                       information, this field contains the tag
                       number assigned to the asset. Represents
                       a short name for a part of an asset.

CVD-ITEM-NBR           Alpha 32                                  AP52.3  PR198
Element: Item Number   If the distribution contains asset
                       information, this field contains the
                       item number of an asset that is composed
                       of different elements, but depreciated
                       as a common asset unit.

CVD-ITEM-DESC          Alpha 30                                  AP52.3  PR198
Element: Item DescriptiIf the distribution contains asset
                       information, this field contains the
                       item description.

CVD-ITEM-QUANTITY      Numeric 8                                 AP52.3  PR198
Element: Item Quantity If the distribution contains asset
                       information, this field contains the
                       number of units that make up the asset
                       item. Each unit of an item is exactly
                       the same as every other unit of the
                       item.

CVD-ASSET-TEMPLATE     Alpha 10                                  AP52.3  PR198
Element: Asset TemplateIf the distribution contains asset
                       information, this field contains the
                       asset template assigned to the
                       distribution. An asset template
                       identifies the required information
                       needed to created asset records.

CVD-INSRV-DATE         Numeric 8  (yyyymmdd)                     AP52.3  PR198
Element: Inservice DateIf the distribution contains asset
                       information, this field contains the
                       in-service date for the asset.

CVD-PURCHASE-DATE      Numeric 8  (yyyymmdd)                     AP52.3  PR198
Element: Purchase Date If the distribution contains asset
                       information, this field contains the
                       date the asset was purchased. This
                       purchased date can be different from the
                       in-service dates for the depreciation
                       books used.

CVD-MODEL-NUMBER       Alpha 30                                  AP52.3  PR198
Element: Model Number  If the distribution contains asset
                       information, this field contains the
                       model number assigned to the asset.

CVD-SERIAL-NUMBER      Alpha 30                                  AP52.3  PR198
Element: Serial Number If the distribution contains asset
                       information, this field contains the
                       serial number associated with the asset.

CVD-HOLD-AM            Alpha 1                                   AP52.3  PR198
Element: Hold Asset    If the distribution contains asset
                       information, this field indicates
                       whether to hold the asset in the Asset
                       Interface file. Being held keeps items
                       from becoming assets until they are
                       released from hold. Valid values are:

                       N = No.
                       Y = Yes.
                       Blank = Distribution does not contain
                       asset information.

CVD-ASSET              Numeric 10                                AP52.3  PR198
Element: Asset Number  If the distribution contains asset
                       information, this field contains the
                       asset number assigned to the
                       distribution.

CVD-ACCT-CATEGORY      Alpha 5                                   AP52.3  PR198
Element: Account CategoThe account category assigned to the
                       distribution, if applicable. Used to
                       group distributions under an activity.
                       Must be a valid record in the Lawson
                       Activity Management system. If left
                       blank, this value defaults from the
                       vendor, if assigned.

CVD-UNT-AMOUNT         Signed 15.2                               AP52.3  PR198
Element: Unit Amount   The total unit amount allocated to the
                       distribution, if applicable.

CVD-ITEM-TAX-TRAN      Signed 15.2                               AP52.3  PR198
Item Tax - Trans       The taxable amount associated with the
Currency               distribution in the currency of the
                       transaction.

CVD-ASSET-GROUP        Alpha 10                                  AP52.3  PR198
Element: Asset Group   If the distribution contains asset
                       information, this field contains the
                       asset group assigned to the
                       distribution.

CVD-COMBINE            Alpha 10                                  AP52.3  PR198
Element: Combine AssetsIf the distribution contains asset
                       information, this field indicates
                       whether to combine items as one asset.

CVD-AU-GROUP           Alpha 10                                  AP52.3
Element: Au Group      Accounting unit groups group and
                       identify the accounting units to use
                       when you create journal entries for
                       adding, adjusting, transferring, or
                       disposing of assets. Changes to
                       accounting unit groups are dynamic,
                       affecting all assets using the
                       accounting unit group. Accounting unit
                       group names are user-definable, and
                       accounting unit groups are set up by
                       company.

CVD-ACCT-UNIT          Alpha 15                                  AP52.3  PR198
Element: Accounting UniThe accounting unit associated with an
                       asset interface distribution. Must be a
                       valid record in the Lawson General
                       Ledger system.

CVD-TAX-POINT          Alpha 1                                   PR198
Element: Tax Point     Indicates when the tax amount is
                       calculated for the distribution, if
                       applicable. Valid values are:

                       I = Invoice.
                       P = Payment.

CVD-PO-AOC-CODE        Alpha 2                                   AP52.3
Element: Add On Cost CoAdd on cost code assigned to a purchase
                       order. Add on costs can be extra costs
                       such as freight costs or other
                       miscellaneous costs, or they can be
                       allowances such as credits or returns.

CVD-DIVISION           Alpha 15                                  AP52.3
Element: Division      A user-defined division which is used
                       for reporting assets.

CVD-LOCATION-NAME      Alpha 15                                  AP52.3
Element: Destination

CVD-TAX-USAGE-CD       Alpha 10                                  AP52.3
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

CVD-DST-USR-FLD-01     Alpha 20                                  AP52.3
Distribution User      Distribution user field 1. Field input
Field 1                must be valid for the user field
                       definition in the AP Company file.

CVD-DST-USR-FLD-02     Alpha 20                                  AP52.3
Distribution User      Distribution user field 2. Field input
Field 2                must be valid for the user field
                       definition in the AP Company file.

CVD-DST-USR-FLD-03     Alpha 20                                  AP52.3
Distribution User      Distribution user field 3. Field input
Field 3                must be valid for the user field
                       definition in the AP Company file.

CVD-DST-USR-FLD-04     Alpha 20                                  AP52.3
Distribution User      Distribution user field 4. Field input
Field 4                must be  valid for the user field
                       definition in the AP Company file.

CVD-DST-USR-FLD-05     Alpha 20                                  AP52.3
Distribution User      Distribution user field 5. Field input
Field 5                must be valid for the user field
                       definition in the AP Company file.

CVD-SEGMENT-BLOCK      Alpha 103                                 AP52.3
Element: User Analysis This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

                         APCDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVDSET1   COMPANY       This index is used to access             AP305   AP52.1
          VENDOR        distribution conversion or interface     AP52.3  AP520
          EDI-NBR       records.                                 PR198
          INVOICE
          SUFFIX
          DIST-SEQ-NBR