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 AP520 PR198 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVD-COMPANY Numeric 4 AP52.3 PR198
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
Vendor ID Required. The vendor number. Must be a
valid record in the Vendor file.
CVD-EDI-NBR Alpha 15 AP52.3 PR198
EDI Number The electronic data interchange (EDI)
number assigned to the vendor.
CVD-INVOICE Alpha 22 AP52.3 PR198
Invoice Number Required. A unique invoice number for
the vendor.
CVD-SUFFIX Numeric 3 AP52.3 PR198
Invoice Suffix The occurrence value of the invoice.
Not valid for invoices with an
unreleased status.
CVD-DIST-SEQ-NBR Numeric 4 AP52.3 PR198
Distribution Required if you have more than one line
Sequence Number 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
Distribution Amount Required. The amount of the invoice
distribution in the currency of the
invoice.
CVD-TAXABLE-AMT Signed 15.2 AP52.3 PR198
Taxable Amount The taxable amount of the invoice
distribution.
CVD-DIST-COMPANY Numeric 4 AP52.3 PR198
Distribution 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 PR198
To Company Base The amount of the distribution in the
Amount 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
Accounting Unit 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.
CVD-DIS-ACCOUNT Numeric 6 AP52.3 PR198
Account Number 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
Subaccount Number 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
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
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
Reference The distribution reference. If left
blank, the default reference value
defined for the company defaults.
CVD-ACTIVITY Alpha 15 AP52.3 PR198
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
Asset Description If the distribution contains asset
information, this field contains the
asset description.
CVD-TAG-NBR Alpha 12 AP52.3 PR198
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
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
Item Description If the distribution contains asset
information, this field contains the
item description.
CVD-ITEM-QUANTITY Numeric 8 AP52.3 PR198
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
Asset Template 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.
CVD-INSRV-DATE Numeric 8 (yyyymmdd) AP52.3 PR198
Inservice Date If the distribution contains asset
information, this field contains the
in-service date for the asset.
CVD-PURCHASE-DATE Numeric 8 (yyyymmdd) AP52.3 PR198
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
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
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
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
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
Account Category 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.
CVD-UNT-AMOUNT Signed 15.2 AP52.3 PR198
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
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
Combine Assets If the distribution contains asset
information, this field indicates
whether to combine items as one asset.
CVD-AU-GROUP Alpha 10 AP52.3
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
Accounting Unit The 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
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
Purchase Order Add Add on cost code assigned to a purchase
On Cost Flg 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
Division A user-defined division which is used
for reporting assets.
CVD-LOCATION-NAME Alpha 15 AP52.3
Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
CVD-TAX-USAGE-CD Alpha 10 AP52.3
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
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
|
