|
|
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 Required. The vendor number. Must be a
valid record in the Vendor file.
CVD-EDI-NBR Alpha 15 AP52.3 PR198
Element: Edi Nbr The electronic data interchange (EDI)
number assigned to the vendor.
CVD-INVOICE Alpha 22 AP52.3 PR198
Element: Invoice Required. A unique invoice number for
the vendor.
CVD-SUFFIX Numeric 3 AP52.3 PR198
Element: Suffix The occurrence value of the invoice.
Not valid for invoices with an
unreleased status.
CVD-DIST-SEQ-NBR Numeric 6 AP52.3 PR198
Element: Dist Seq Nbr 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.
CVD-ORIG-TRAN-AMT Signed 18.2 AP52.3 PR198
Element: Intl Amt Required. The amount of the invoice
distribution in the currency of the
invoice.
CVD-TAXABLE-AMT Signed 18.2 AP52.3 PR198
Element: Intl 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 18.2 AP52.3 PR198
Element: Intl 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: Acct 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
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: Sub Acct 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-INDICATOR Numeric 1 AP52.3
Element: Tax Indicator
CVD-TAX-SEQ-NBR Numeric 4
Element: Tax Seq Nbr
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 Desc If 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 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: Acct 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-BILL-CATEGORY Alpha 32 AP52.3
Element: Bill Category
CVD-UNT-AMOUNT Signed 18.2 AP52.3 PR198
Element: Unit Amount The total unit amount allocated to the
distribution, if applicable.
CVD-ITEM-TAX-TRAN Signed 18.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: Acct 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
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: Aoc Code 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.
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: Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
CVD-BAR-CODE Alpha 30 AP52.3
Element: Bar Code
CVD-ITEM-LOC-DTL Alpha 14 AP52.3
Element: Item Loc Dtl
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: Segment Block 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-ICN-CODE Alpha 8 AP52.3
Element: Icn Code
CVD-WEIGHT Signed 9.3 AP52.3
Element: Weight This field contains the unit weight of
the item based on the stocking UOM.
CVD-SUPLMNTARY-QTY Signed 13.4 AP52.3
Element: Quantity This field contains the desired
quantity.
CVD-LINE-TYPE Alpha 1 AP52.3
Element: Line Type This field contains the type of
inventory on this line.
APCDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVDSET1 COMPANY AP305 AP52.1
VENDOR AP52.3 AP520
EDI-NBR PR198
INVOICE
SUFFIX
DIST-SEQ-NBR
|
