POCLINE – No description in the Lawson data dictionary

System: Purchase Order (PO)
Prefix: CAL
Primary key: PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, REC-TYP
Fields: 76
Updated by: 4 programs
Referenced by: 0 programs

POCLINE is a Lawson Purchase Order table (prefix CAL); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, REC-TYP (CALSET1). It is updated by PO520, PO53.1, PO53.2 and PO55.2. The table has 76 fields, 1 index and 0 documented relations.

About POCLINE

No description in the Lawson data dictionary.

Fields (76)

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

Field / column	Type	Description & values	Updated by
`CAL-PROCURE-GROUP` PK PROCURE_GROUP	Alpha 4	This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.	PO520, PO53.2
`CAL-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	PO520, PO53.2
`CAL-PO-NUMBER` PK PO_NUMBER	Alpha 14 (Right Justified)	This field contains the number representing the purchase order.	PO520, PO53.2
`CAL-PO-RELEASE` PK PO_RELEASE	Numeric 4	Used to identify a purchase order release (created from a Blanket or Standing order).	PO520, PO53.2
`CAL-PO-CODE` PK PO_CODE	Alpha 4	This is the purchase order code.	PO520, PO53.2
`CAL-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the line number.	PO520, PO53.2
`CAL-REC-TYP` PK REC_TYP	Numeric 2	—	PO520, PO53.2
`CAL-ITEM` ITEM	Alpha 32	This field contains the item identifier.	PO520, PO53.2
`CAL-ITEM-TYPE` ITEM_TYPE	Alpha 1	This field identifies the line item type. `I` Invnetoried `S` Service `X` Special `N` Non-Stock	PO520, PO53.2
`CAL-SERVICE-CODE` SERVICE_CODE	Alpha 1	—	PO520, PO53.2
`CAL-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	PO520, PO53.2
`CAL-QUANTITY` QUANTITY	Signed 13.4	This field contains the desired quantity.	PO520, PO53.2
`CAL-AGREEMENT-REF` AGREEMENT_REF	Alpha 30	—	PO520, PO53.2
`CAL-ENT-UNIT-CST` ENT_UNIT_CST	Signed 18.5	—	PO520, PO53.2
`CAL-TAXBL-UNT-CST` TAXBL_UNT_CST	Signed 18.5	—	PO520, PO53.2
`CAL-ENT-BUY-UOM` ENT_BUY_UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	PO520, PO53.2
`CAL-EARLY-DL-DATE` EARLY_DL_DATE	Numeric 8 (yyyymmdd)	This field contains the early delivery date.	PO520, PO53.2
`CAL-LATE-DL-DATE` LATE_DL_DATE	Numeric 8 (yyyymmdd)	This field contains the late delivery date.	PO520, PO53.2
`CAL-LOCATION` LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	PO520, PO53.2
`CAL-VEN-ITEM` VEN_ITEM	Alpha 32	This field contains the item identifier.	PO520, PO53.2
`CAL-DIST-CODE` DIST_CODE	Alpha 9	A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions.	PO520, PO53.2
`CAL-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	PO520, PO53.2
`CAL-WEIGHT` WEIGHT	Signed 9.3	This field contains the unit weight of the item based on the stocking UOM.	PO520, PO53.2
`CAL-CUBIC-FEET` CUBIC_FEET	Signed 9.3	This field contains the unit cubic feet of the item based on the stocking UOM.	PO520, PO53.2
`CAL-COST-OPTION` COST_OPTION	Alpha 1	— `1` Cosr Required `2` No Charge `3` Vendor Determined	PO520, PO53.2
`CAL-CERT-REQ-FL` CERT_REQ_FL	Alpha 1	This flag indicates whether a certification is required for this line when it is purchased. This field value is passed to the PO when the PO line is created. Valid values are: `N` Certification not required. `Y` Certification required.	PO520, PO53.2
`CAL-INSP-REQ-FL` INSP_REQ_FL	Alpha 1	— `N` No `Y` Yes	PO520, PO53.2
`CAL-MSDS-FLAG` MSDS_FLAG	Alpha 1	—	PO520, PO53.2
`CAL-NO-LT-CALC-FL` NO_LT_CALC_FL	Alpha 1	— `N` No `Y` Yes	PO520, PO53.2
`CAL-TAXABLE-FLAG` TAXABLE_FLAG	Alpha 1	Defines if Taxable. `N` No `Y` Yes	PO520, PO53.2
`CAL-OSHIP-TOL-PCT` OSHIP_TOL_PCT	Percent 5.3 (Percent)	Quantity overshipment tolerance percentage.	PO520, PO53.2
`CAL-USHIP-TOL-PCT` USHIP_TOL_PCT	Percent 6.3 (Percent)	This is the quantity undership percentage for automatic back order cancellation. If a value of 10% is entered here, for instance, and a quantity of 91 is shipped against an ordered quantity of 100, that would be considered a 9% undershipment. Since this is less than the 10% limit, the backordered amount would be cancelled. This process takes place at receiving time. If a backorder is not cancelled manually, the system checks, in order, the PO line, the PO vendor purchase from record, the PO vendor record, and the company record. If an undershipment percentage of a zero percent flag set to Y is encountered at any level, that value is used. NOTE The percentage can be set at 100%, which would cancel all backorders.	PO520, PO53.2
`CAL-USER-DATE-3` USER_DATE_3	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	PO520, PO53.2
`CAL-USER-DATE-4` USER_DATE_4	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	PO520, PO53.2
`CAL-PURCH-MAJCL` PURCH_MAJCL	Alpha 4	—	PO520, PO53.2
`CAL-PURCH-MINCL` PURCH_MINCL	Alpha 4	—	PO520, PO53.2
`CAL-MANUF-CODE` MANUF_CODE	Alpha 4	This field contains a user defined code that indicates the manufacturer of an item.	PO520, PO53.2
`CAL-MANUF-DIVISION` MANUF_DIVISION	Alpha 4	This is a user defined code that indicates which division of a manufacturer is tied to an item.	PO520, PO53.2
`CAL-MANUF-NBR` MANUF_NBR	Alpha 35	This is the identifier that the manufacturer has assigned to an item.	PO520, PO53.2
`CAL-CLOSED-FL` CLOSED_FL	Alpha 1	The Closed Flag.	PO520, PO53.2
`CAL-ZERO-OSHIP-FL` ZERO_OSHIP_FL	Alpha 1	—	PO520, PO53.2
`CAL-ZERO-USHIP-FL` ZERO_USHIP_FL	Alpha 1	—	PO520, PO53.2
`CAL-EXCL-AOC-SPRD` EXCL_AOC_SPRD	Alpha 1	Exclude this line item from the Add On Cost Spread Methods.	PO520, PO53.2
`CAL-PO-USER-FLD-2` PO_USER_FLD_2	Alpha 2	Purchase order line user defined field.	PO520, PO53.2
`CAL-PO-USER-FLD-4` PO_USER_FLD_4	Alpha 30 (Lower Case)	—	PO520, PO53.2
`CAL-PO-USER-FLD-6` PO_USER_FLD_6	Alpha 15 (Lower Case)	—	PO520, PO53.2
`CAL-ELEMENT-01` ELEMENT_01	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-02` ELEMENT_02	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-03` ELEMENT_03	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-04` ELEMENT_04	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-05` ELEMENT_05	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-06` ELEMENT_06	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-07` ELEMENT_07	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-08` ELEMENT_08	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-09` ELEMENT_09	Alpha 32	—	PO520, PO53.2
`CAL-ELEMENT-10` ELEMENT_10	Alpha 32	—	PO520, PO53.2
`CAL-PLI-USR-FLD-01` PLI_USR_FLD_01	Alpha 20	—	PO520, PO53.2
`CAL-PLI-USR-FLD-02` PLI_USR_FLD_02	Alpha 20	—	PO520, PO53.2
`CAL-PLI-USR-FLD-03` PLI_USR_FLD_03	Alpha 20	—	PO520, PO53.2
`CAL-PLI-USR-FLD-04` PLI_USR_FLD_04	Alpha 20	—	PO520, PO53.2
`CAL-PLI-USR-FLD-05` PLI_USR_FLD_05	Alpha 20	—	PO520, PO53.2
`CAL-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.	PO520, PO53.2
`CAL-ICN-CODE` ICN_CODE	Alpha 8	—	PO520, PO53.2
`CAL-SUPLMNTARY-QTY` SUPLMNTARY_QTY	Signed 13.4	This field contains the desired quantity.	PO520, PO53.2
`CAL-PLI-SEG-BLOCK` PLI_SEG_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.	PO520, PO53.2
`CAL-COMMODITY-CODE` COMMODITY_CODE	Alpha 35	—	PO53.2
`CAL-RETAINAGE` RETAINAGE	Numeric 1	— `0` No `1` Yes	PO520, PO55.2
`CAL-RET-PCT-1` RET_PCT_1	Percent 5.2 (Percent)	—	PO520, PO55.2
`CAL-RET-PCT-2` RET_PCT_2	Percent 5.2 (Percent)	—	PO520, PO55.2
`CAL-RET-UP-TO-PCT` RET_UP_TO_PCT	Percent 5.2 (Percent)	—	PO520, PO55.2
`CAL-RET-OVRD-PCT` RET_OVRD_PCT	Percent 5.2 (Percent)	—	PO520, PO55.2
`CAL-ORIG-LINE-NBR` ORIG_LINE_NBR	Numeric 6	—	—
`CAL-RUN-GROUP` RUN_GROUP	Alpha 15	—	PO520, PO53.2
`CAL-PROD-TAX-CAT` PROD_TAX_CAT	Alpha 15	—	PO520
`CAL-GTIN` GTIN	Numeric 14	—	PO53.2
`CAL-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	PO520, PO53.2

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
`CALSET1`	`PROCURE-GROUP`, `COMPANY`, `PO-NUMBER`, `PO-RELEASE`, `PO-CODE`, `LINE-NBR`, `REC-TYP`	Primary		PO520, PO53.1, PO53.2, PO53.3, PO55.2

Programs

Updated by (4)

PO520 Purchase Order Interface from Non Lawson
PO53.1 Purchase Order Interface
PO53.2 Purchase Order Line Interface
PO55.2 Purchase Order Line Retainage Interface