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 Element: Company	Numeric 4 Required. The company number. Must be a valid record in the Accounts Payable Company file.	AP52.3 PR198
CVD-VENDOR Element: Vendor	Alpha 9 (Right Justified) Required. The vendor number. Must be a valid record in the Vendor file.	AP52.3 PR198
CVD-EDI-NBR Element: Edi Nbr	Alpha 15 The electronic data interchange (EDI) number assigned to the vendor.	AP52.3 PR198
CVD-INVOICE Element: Invoice	Alpha 22 Required. A unique invoice number for the vendor.	AP52.3 PR198
CVD-SUFFIX Element: Suffix	Numeric 3 The occurrence value of the invoice. Not valid for invoices with an unreleased status.	AP52.3 PR198
CVD-DIST-SEQ-NBR Element: Dist Seq Nbr	Numeric 6 Required 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.	AP52.3 PR198
CVD-ORIG-TRAN-AMT Element: Intl Amt	Signed 18.2 Required. The amount of the invoice distribution in the currency of the invoice.	AP52.3 PR198
CVD-TAXABLE-AMT Element: Intl Amt	Signed 18.2 The taxable amount of the invoice distribution.	AP52.3 PR198
CVD-DIST-COMPANY Element: Company	Numeric 4 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.	AP52.3 PR198
CVD-TO-BASE-AMT Element: Intl Amt	Signed 18.2 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).	AP52.3 PR198
CVD-DIS-ACCT-UNIT Element: Acct Unit	Alpha 15 Required 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.	AP52.3 PR198
CVD-DIS-ACCOUNT Element: Account	Numeric 6 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.	AP52.3 PR198
CVD-DIS-SUB-ACCT Element: Sub Acct	Numeric 4 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.	AP52.3 PR198
CVD-TAX-INDICATOR Element: Tax Indicator	Numeric 1	AP52.3
CVD-TAX-SEQ-NBR Element: Tax Seq Nbr	Numeric 4
CVD-TAX-CODE Element: Tax Code	Alpha 10 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.	AP52.3 PR198
CVD-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The distribution description. If left blank, the vendor number and vendor name defaults. This field accepts both upper and lower case entries.	AP52.3 PR198
CVD-DST-REFERENCE Element: Cross Ref	Alpha 10 The distribution reference. If left blank, the default reference value defined for the company defaults.	AP52.3 PR198
CVD-ACTIVITY Element: Activity	Alpha 15 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.	AP52.3 PR198
CVD-ASSET-DESC Element: Asset Description	Alpha 30 (Lower Case) If the distribution contains asset information, this field contains the asset description.	AP52.3 PR198
CVD-TAG-NBR Element: Tag Number	Alpha 12 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.	AP52.3 PR198
CVD-ITEM-NBR Element: Item Number	Alpha 32 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.	AP52.3 PR198
CVD-ITEM-DESC Element: Item Desc	Alpha 30 If the distribution contains asset information, this field contains the item description.	AP52.3 PR198
CVD-ITEM-QUANTITY Element: Item Quantity	Numeric 8 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.	AP52.3 PR198
CVD-ASSET-TEMPLATE Element: Asset Template	Alpha 10 If 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.	AP52.3 PR198
CVD-INSRV-DATE Element: Inservice Date	Numeric 8 (yyyymmdd) If the distribution contains asset information, this field contains the in-service date for the asset.	AP52.3 PR198
CVD-PURCHASE-DATE Element: Purchase Date	Numeric 8 (yyyymmdd) 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.	AP52.3 PR198
CVD-MODEL-NUMBER Element: Model Number	Alpha 30 If the distribution contains asset information, this field contains the model number assigned to the asset.	AP52.3 PR198
CVD-SERIAL-NUMBER Element: Serial Number	Alpha 30 If the distribution contains asset information, this field contains the serial number associated with the asset.	AP52.3 PR198
CVD-HOLD-AM Element: Hold Asset	Alpha 1 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.	AP52.3 PR198
CVD-ASSET Element: Asset	Numeric 10 If the distribution contains asset information, this field contains the asset number assigned to the distribution.	AP52.3 PR198
CVD-ACCT-CATEGORY Element: Acct Category	Alpha 5 The 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.	AP52.3 PR198
CVD-BILL-CATEGORY Element: Bill Category	Alpha 32	AP52.3
CVD-UNT-AMOUNT Element: Unit Amount	Signed 18.2 The total unit amount allocated to the distribution, if applicable.	AP52.3 PR198
CVD-ITEM-TAX-TRAN Item Tax - Trans Currency	Signed 18.2 The taxable amount associated with the distribution in the currency of the transaction.	AP52.3 PR198
CVD-ASSET-GROUP Element: Asset Group	Alpha 10 If the distribution contains asset information, this field contains the asset group assigned to the distribution.	AP52.3 PR198
CVD-COMBINE Element: Combine Assets	Alpha 10 If the distribution contains asset information, this field indicates whether to combine items as one asset.	AP52.3 PR198
CVD-AU-GROUP Element: Au Group	Alpha 10 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.	AP52.3
CVD-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit associated with an asset interface distribution. Must be a valid record in the Lawson General Ledger system.	AP52.3 PR198
CVD-TAX-POINT Element: Tax Point	Alpha 1 Indicates when the tax amount is calculated for the distribution, if applicable. Valid values are: I = Invoice. P = Payment.	PR198
CVD-PO-AOC-CODE Element: Aoc Code	Alpha 2 Add 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.	AP52.3
CVD-DIVISION Element: Division	Alpha 15 A user-defined division which is used for reporting assets.	AP52.3
CVD-LOCATION-NAME Element: Location Name	Alpha 15 A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.	AP52.3
CVD-BAR-CODE Element: Bar Code	Alpha 30	AP52.3
CVD-ITEM-LOC-DTL Element: Item Loc Dtl	Alpha 14	AP52.3
CVD-TAX-USAGE-CD Element: Tax Usage Cd	Alpha 10 The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.	AP52.3
CVD-DST-USR-FLD-01 Distribution User Field 1	Alpha 20 Distribution user field 1. Field input must be valid for the user field definition in the AP Company file.	AP52.3
CVD-DST-USR-FLD-02 Distribution User Field 2	Alpha 20 Distribution user field 2. Field input must be valid for the user field definition in the AP Company file.	AP52.3
CVD-DST-USR-FLD-03 Distribution User Field 3	Alpha 20 Distribution user field 3. Field input must be valid for the user field definition in the AP Company file.	AP52.3
CVD-DST-USR-FLD-04 Distribution User Field 4	Alpha 20 Distribution user field 4. Field input must be valid for the user field definition in the AP Company file.	AP52.3
CVD-DST-USR-FLD-05 Distribution User Field 5	Alpha 20 Distribution user field 5. Field input must be valid for the user field definition in the AP Company file.	AP52.3
CVD-SEGMENT-BLOCK Element: Segment Block	Alpha 103 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.	AP52.3
CVD-ICN-CODE Element: Icn Code	Alpha 8	AP52.3
CVD-WEIGHT Element: Weight	Signed 9.3 This field contains the unit weight of the item based on the stocking UOM.	AP52.3
CVD-SUPLMNTARY-QTY Element: Quantity	Signed 13.4 This field contains the desired quantity.	AP52.3
CVD-LINE-TYPE Element: Line Type	Alpha 1 This field contains the type of inventory on this line.	AP52.3

APCDISTRIB FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.