|
|
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 PR199
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVD-COMPANY Numeric 4 AP52.3 PR199
Company Required. The company number. Must be a
valid record in the Accounts Payable
Company file.
CVD-VENDOR Alpha 9 AP52.3 PR199
Vendor ID Required. The vendor number. Must be a
valid record in the Vendor file.
CVD-EDI-NBR Alpha 15 AP52.3 PR199
EDI Number The electronic data interchange (EDI)
number assigned to the vendor.
CVD-INVOICE Alpha 22 AP52.3 PR199
Invoice Number Required. A unique invoice number for
the vendor.
CVD-SUFFIX Numeric 3 AP52.3 PR199
Invoice Suffix The occurrence value of the invoice.
Not valid for invoices with an
unreleased status.
CVD-DIST-SEQ-NBR Numeric 4 AP52.3 PR199
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 PR199
Distribution Amount Required. The amount of the invoice
distribution in the currency of the
invoice.
CVD-TAXABLE-AMT Signed 15.2 AP52.3 PR199
Taxable Amount The taxable amount of the invoice
distribution.
CVD-DIST-COMPANY Numeric 4 AP52.3 PR199
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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
Reference The distribution reference. If left
blank, the default reference value
defined for the company defaults.
CVD-ACTIVITY Alpha 15 AP52.3 PR199
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 PR199
Asset Description If the distribution contains asset
information, this field contains the
asset description.
CVD-TAG-NBR Alpha 12 AP52.3 PR199
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 PR199
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 PR199
Item Description If the distribution contains asset
information, this field contains the
item description.
CVD-ITEM-QUANTITY Numeric 8 AP52.3 PR199
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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
Hold 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 PR199
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 PR199
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 PR199
Unit Amount The total unit amount allocated to the
distribution, if applicable.
CVD-ITEM-TAX-TRAN Signed 15.2 AP52.3 PR199
Item Transaction The taxable amount associated with the
Tax Amount distribution in the currency of the
transaction.
CVD-ASSET-GROUP Alpha 10 AP52.3 PR199
Asset Group If the distribution contains asset
information, this field contains the
asset group assigned to the
distribution.
CVD-COMBINE Alpha 10 AP52.3 PR199
Combine If the distribution contains asset
information, this field indicates
whether to combine items as one asset.
CVD-ACCT-UNIT Alpha 15 AP52.3 PR199
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 PR199
Tax Point Indicates when the tax amount is
calculated for the distribution, if
applicable. Valid values are:
I = Invoice.
P = Payment.
CVD-LINE-TYPE Alpha 1 AP52.3
Line Type This field contains the type of
inventory on this line.
G - Goods
S - Services
CVD-COMMODITY Alpha 8 AP52.3
Commodity The Intrastat commodity code.
Represents a category of goods. Must be
defined in IN03.1 (Commodity
Maintenance).
CVD-WEIGHT Signed 9.3 AP52.3
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
CVD-SECONDARY-QTY Signed 13.4 AP52.3
Secondary Quantity This field contains the secondary
quantity, which is tracked if the item
is a catch weight item. This quantity
is a memo quantity only. It is not used
for valuation.
CVD-SEC-UOM Alpha 4 AP52.3
Secondary Unit of This field contains the secondary
Measure quantity unit of measure.
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.
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.
APCDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVDSET1 COMPANY This index is used to access AP52.1 AP52.3
VENDOR distribution conversion or interface AP520 PR199
EDI-NBR records.
INVOICE
SUFFIX
DIST-SEQ-NBR
|