APCDISTRIB

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVDSET1 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
DIST-SEQ-NBR
AP305 AP52.1
AP52.3 AP520
PR198


File created: Wed Jun 08 20:47:28 2016

Home
Contact Us



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