APCDISTRIB – Distribution Interface

System: Accounts Payable (AP)
Prefix: CVD
Primary key: COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ-NBR
Fields: 56
Updated by: 5 programs
Referenced by: 0 programs

APCDISTRIB is the Distribution Interface table in Lawson Accounts Payable (prefix CVD). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ-NBR (CVDSET1). It is updated by AP305, AP52.1, AP52.3, AP520 and PR198. The table has 56 fields, 1 index and 0 documented relations.

About APCDISTRIB

No description in the Lawson data dictionary.

Fields (56)

Column = COBOL field name without the CVD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CVD-COMPANY` PK COMPANY	Numeric 4	Required. The company number. Must be a valid record in the Accounts Payable Company file.	AP52.3, PR198
`CVD-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	Required. The vendor number. Must be a valid record in the Vendor file.	AP52.3, PR198
`CVD-EDI-NBR` PK EDI_NBR	Alpha 15	The electronic data interchange (EDI) number assigned to the vendor.	AP52.3, PR198
`CVD-INVOICE` PK INVOICE	Alpha 22	Required. A unique invoice number for the vendor.	AP52.3, PR198
`CVD-SUFFIX` PK SUFFIX	Numeric 3	The occurrence value of the invoice. Not valid for invoices with an unreleased status.	AP52.3, PR198
`CVD-DIST-SEQ-NBR` PK 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` ORIG_TRAN_AMT	Signed 18.2	Required. The amount of the invoice distribution in the currency of the invoice.	AP52.3, PR198
`CVD-TAXABLE-AMT` TAXABLE_AMT	Signed 18.2	The taxable amount of the invoice distribution.	AP52.3, PR198
`CVD-DIST-COMPANY` DIST_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` TO_BASE_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` DIS_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` DIS_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` DIS_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` TAX_INDICATOR	Numeric 1	—	AP52.3
`CVD-TAX-SEQ-NBR` TAX_SEQ_NBR	Numeric 4	—	—
`CVD-TAX-CODE` 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` 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` DST_REFERENCE	Alpha 10	The distribution reference. If left blank, the default reference value defined for the company defaults.	AP52.3, PR198
`CVD-ACTIVITY` 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` ASSET_DESC	Alpha 30 (Lower Case)	If the distribution contains asset information, this field contains the asset description.	AP52.3, PR198
`CVD-TAG-NBR` TAG_NBR	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` ITEM_NBR	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` ITEM_DESC	Alpha 30	If the distribution contains asset information, this field contains the item description.	AP52.3, PR198
`CVD-ITEM-QUANTITY` 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` 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` INSRV_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` 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` 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` 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` HOLD_AM	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: asset information. `N` No. `Y` Yes. `Blank` Distribution does not contain	AP52.3, PR198
`CVD-ASSET` 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` 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` BILL_CATEGORY	Alpha 32	—	AP52.3
`CVD-UNT-AMOUNT` UNT_AMOUNT	Signed 18.2	The total unit amount allocated to the distribution, if applicable.	AP52.3, PR198
`CVD-ITEM-TAX-TRAN` ITEM_TAX_TRAN	Signed 18.2	The taxable amount associated with the distribution in the currency of the transaction.	AP52.3, PR198
`CVD-ASSET-GROUP` 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` COMBINE	Alpha 10	If the distribution contains asset information, this field indicates whether to combine items as one asset.	AP52.3, PR198
`CVD-AU-GROUP` 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` 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` 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` PO_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` DIVISION	Alpha 15	A user-defined division which is used for reporting assets.	AP52.3
`CVD-LOCATION-NAME` 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` BAR_CODE	Alpha 30	—	AP52.3
`CVD-ITEM-LOC-DTL` ITEM_LOC_DTL	Alpha 14	—	AP52.3
`CVD-TAX-USAGE-CD` 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` DST_USR_FLD_01	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` DST_USR_FLD_02	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` DST_USR_FLD_03	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` DST_USR_FLD_04	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` DST_USR_FLD_05	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` 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` ICN_CODE	Alpha 8	—	AP52.3
`CVD-WEIGHT` WEIGHT	Signed 9.3	This field contains the unit weight of the item based on the stocking UOM.	AP52.3
`CVD-SUPLMNTARY-QTY` SUPLMNTARY_QTY	Signed 13.4	This field contains the desired quantity.	AP52.3
`CVD-LINE-TYPE` LINE_TYPE	Alpha 1	This field contains the type of inventory on this line.	AP52.3

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CVDSET1`	`COMPANY`, `VENDOR`, `EDI-NBR`, `INVOICE`, `SUFFIX`, `DIST-SEQ-NBR`	Primary		AP305, AP52.1, AP52.3, AP520, PR198

Programs

Updated by (5)

AP305 Accounts Payable Company Purge
AP52.1 Invoice Interface
AP52.3 Distribution Interface
AP520 Invoice Interface
PR198 General Ledger Posting