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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#CVD-COMPANY PKCOMPANY | Numeric 4 | Required. The company number. Must be a valid record in the Accounts Payable Company file. | AP52.3, PR198 |
#CVD-VENDOR PKVENDOR | Alpha 9 (Right Justified) | Required. The vendor number. Must be a valid record in the Vendor file. | AP52.3, PR198 |
#CVD-EDI-NBR PKEDI_NBR | Alpha 15 | The electronic data interchange (EDI) number assigned to the vendor. | AP52.3, PR198 |
#CVD-INVOICE PKINVOICE | Alpha 22 | Required. A unique invoice number for the vendor. | AP52.3, PR198 |
#CVD-SUFFIX PKSUFFIX | Numeric 3 | The occurrence value of the invoice. Not valid for invoices with an unreleased status. | AP52.3, PR198 |
#CVD-DIST-SEQ-NBR PKDIST_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-AMTORIG_TRAN_AMT | Signed 18.2 | Required. The amount of the invoice distribution in the currency of the invoice. | AP52.3, PR198 |
#CVD-TAXABLE-AMTTAXABLE_AMT | Signed 18.2 | The taxable amount of the invoice distribution. | AP52.3, PR198 |
#CVD-DIST-COMPANYDIST_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-AMTTO_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-UNITDIS_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-ACCOUNTDIS_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-ACCTDIS_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-INDICATORTAX_INDICATOR | Numeric 1 | — | AP52.3 |
#CVD-TAX-SEQ-NBRTAX_SEQ_NBR | Numeric 4 | — | — |
#CVD-TAX-CODETAX_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-DESCRIPTIONDESCRIPTION | 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-REFERENCEDST_REFERENCE | Alpha 10 | The distribution reference. If left blank, the default reference value defined for the company defaults. | AP52.3, PR198 |
#CVD-ACTIVITYACTIVITY | 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-DESCASSET_DESC | Alpha 30 (Lower Case) | If the distribution contains asset information, this field contains the asset description. | AP52.3, PR198 |
#CVD-TAG-NBRTAG_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-NBRITEM_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-DESCITEM_DESC | Alpha 30 | If the distribution contains asset information, this field contains the item description. | AP52.3, PR198 |
#CVD-ITEM-QUANTITYITEM_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-TEMPLATEASSET_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-DATEINSRV_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-DATEPURCHASE_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-NUMBERMODEL_NUMBER | Alpha 30 | If the distribution contains asset information, this field contains the model number assigned to the asset. | AP52.3, PR198 |
#CVD-SERIAL-NUMBERSERIAL_NUMBER | Alpha 30 | If the distribution contains asset information, this field contains the serial number associated with the asset. | AP52.3, PR198 |
#CVD-HOLD-AMHOLD_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.
| AP52.3, PR198 |
#CVD-ASSETASSET | Numeric 10 | If the distribution contains asset information, this field contains the asset number assigned to the distribution. | AP52.3, PR198 |
#CVD-ACCT-CATEGORYACCT_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-CATEGORYBILL_CATEGORY | Alpha 32 | — | AP52.3 |
#CVD-UNT-AMOUNTUNT_AMOUNT | Signed 18.2 | The total unit amount allocated to the distribution, if applicable. | AP52.3, PR198 |
#CVD-ITEM-TAX-TRANITEM_TAX_TRAN | Signed 18.2 | The taxable amount associated with the distribution in the currency of the transaction. | AP52.3, PR198 |
#CVD-ASSET-GROUPASSET_GROUP | Alpha 10 | If the distribution contains asset information, this field contains the asset group assigned to the distribution. | AP52.3, PR198 |
#CVD-COMBINECOMBINE | Alpha 10 | If the distribution contains asset information, this field indicates whether to combine items as one asset. | AP52.3, PR198 |
#CVD-AU-GROUPAU_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-UNITACCT_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-POINTTAX_POINT | Alpha 1 | Indicates when the tax amount is calculated for the distribution, if applicable. Valid values are:
| PR198 |
#CVD-PO-AOC-CODEPO_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-DIVISIONDIVISION | Alpha 15 | A user-defined division which is used for reporting assets. | AP52.3 |
#CVD-LOCATION-NAMELOCATION_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-CODEBAR_CODE | Alpha 30 | — | AP52.3 |
#CVD-ITEM-LOC-DTLITEM_LOC_DTL | Alpha 14 | — | AP52.3 |
#CVD-TAX-USAGE-CDTAX_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-01DST_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-02DST_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-03DST_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-04DST_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-05DST_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-BLOCKSEGMENT_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-CODEICN_CODE | Alpha 8 | — | AP52.3 |
#CVD-WEIGHTWEIGHT | Signed 9.3 | This field contains the unit weight of the item based on the stocking UOM. | AP52.3 |
#CVD-SUPLMNTARY-QTYSUPLMNTARY_QTY | Signed 13.4 | This field contains the desired quantity. | AP52.3 |
#CVD-LINE-TYPELINE_TYPE | Alpha 1 | This field contains the type of inventory on this line. | AP52.3 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CVDSET1 |
| Primary | AP305, AP52.1, AP52.3, AP520, PR198 |