|
|
POCLINE FILE
UPDATED BY
PO520 PO53.2 PO53.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAL-PROCURE-GROUP Alpha 4 PO520 PO53.2
Element: Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
CAL-COMPANY Numeric 4 PO520 PO53.2
Element: Company 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.
CAL-PO-NUMBER Alpha 14 (Right Justified) PO520 PO53.2
Element: PO Number This field contains the number
representing the purchase order.
CAL-PO-RELEASE Numeric 4 PO520 PO53.2
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
CAL-PO-CODE Alpha 4 PO520 PO53.2
Element: Po Code This is the purchase order code.
CAL-LINE-NBR Numeric 6 PO520 PO53.2
Element: Line Number This field contains the line number.
CAL-REC-TYP Numeric 2 PO520 PO53.2
Element: Rec Typ
CAL-ITEM Alpha 32 PO520 PO53.2
Element: Item Number This field contains the item
identifier.
CAL-ITEM-TYPE Alpha 1 PO520 PO53.2
Element: Item Type This field identifies the line item
type.
I = Invnetoried
S = Service
X = Special
N = Non-Stock
CAL-SERVICE-CODE Alpha 1 PO520 PO53.2
Element: Service Code
CAL-DESCRIPTION Alpha 30 (Lower Case) PO520 PO53.2
Element: Description This field displays the description.
CAL-QUANTITY Signed 13.4 PO520 PO53.2
Element: Quantity This field contains the desired
quantity.
CAL-AGREEMENT-REF Alpha 30 PO520 PO53.2
Element: Agreement Ref
CAL-ENT-UNIT-CST Signed 18.5 PO520 PO53.2
Element: Intl Cost The entered unit cost.
CAL-TAXBL-UNT-CST Signed 18.5 PO520 PO53.2
Element: Intl Cost The portion of the line unit cost which
is taxable. If left blank, this field
will default to the line unit cost in
vendor price unit of measure terms.
CAL-ENT-BUY-UOM Alpha 4 PO520 PO53.2
Element: Unit of MeasurEntered Buy Unit Of Measure.
CAL-EARLY-DL-DATE Numeric 8 (yyyymmdd) PO520 PO53.2
Early Delivery Date This field contains the early delivery
(Rqst DT) date.
CAL-LATE-DL-DATE Numeric 8 (yyyymmdd) PO520 PO53.2
Element: Late Delivery This field contains the late delivery
date.
CAL-LOCATION Alpha 5 PO520 PO53.2
Element: Location Code This field contains a valid stocking
location within the company inventory.
CAL-VEN-ITEM Alpha 32 PO520 PO53.2
Element: Item Number The vendor's item identifer.
CAL-DIST-CODE Alpha 9 PO520 PO53.2
Element: Distribution CA user-defined code used to
automatically create expense
distributions or expense distribution
"shells" for invoices or to split an
invoice distribution into multiple
distributions.
CAL-TAX-CODE Alpha 10 PO520 PO53.2
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
CAL-WEIGHT Signed 9.3 PO520 PO53.2
Element: Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
CAL-CUBIC-FEET Signed 9.3 PO520 PO53.2
Element: Cubic Feet This field contains the unit cubit feet
of the item based on the stocking UOM.
CAL-COST-OPTION Alpha 1 PO520 PO53.2
Element: Cost Option 1 = Cosr Required
2 = No Charge
3 = Vendor Determined
CAL-CERT-REQ-FL Alpha 1 PO520 PO53.2
Certification This flag indicates whether a
Required Flag 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.
N = No
Y = Yes
CAL-INSP-REQ-FL Alpha 1 PO520 PO53.2
Element: All Flag This flag indicates whether this item
has to be inspected when received via
PO.
N = No
Y = Yes
CAL-MSDS-FLAG Alpha 1 PO520 PO53.2
Element: All Flag This flag indicates if this item
requires a Material Safety Data Sheet.
CAL-NO-LT-CALC-FL Alpha 1 PO520 PO53.2
Element: All Flag N = No
Y = Yes
CAL-TAXABLE-FLAG Alpha 1 PO520 PO53.2
Taxable or Defines if Taxable.
Non-Taxable Flag N = No
Y = Yes
CAL-OSHIP-TOL-PCT Percent 5.3 (Percent) PO520 PO53.2
Overshipment Quantity overshipment tolerance
Tolerance Percent percentage.
CAL-USHIP-TOL-PCT Percent 6.3 (Percent) PO520 PO53.2
Cancel Backorder This is the quantity undership
Percent 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.
CAL-USER-DATE-3 Numeric 8 (yyyymmdd) PO520 PO53.2
Element: Date This field contains the third
user-definable date.
CAL-USER-DATE-4 Numeric 8 (yyyymmdd) PO520 PO53.2
Element: Date This field contains the fourth
user-definable date.
CAL-PURCH-MAJCL Alpha 4 PO520 PO53.2
Element: Major Class The user defined Major Purchasing Class
identifier.
CAL-PURCH-MINCL Alpha 4 PO520 PO53.2
Element: Minor Class The user defined Minor purchasing Class
identifier.
CAL-MANUF-CODE Alpha 4 PO520 PO53.2
Element: Manufacturer'sThis field contains a user defined code
that indicates the manufacturer of an
item.
CAL-MANUF-DIVISION Alpha 4 PO520 PO53.2
Manufacturer's This is a user defined code that
Division indicates which division of a
manufacturer is tied to an item.
CAL-MANUF-NBR Alpha 15 PO520 PO53.2
Manufacturer's Item This is the identifier that the
Number manufacturer has assigned to an item.
CAL-CLOSED-FL Alpha 1 PO520 PO53.2
Element: Closed Flag The Closed Flag.
CAL-ZERO-OSHIP-FL Alpha 1 PO520 PO53.2
Element: All Flag
CAL-ZERO-USHIP-FL Alpha 1 PO520 PO53.2
Element: All Flag Set this flag to "Y" to indicate that
the undershipment tolerance percent
should be set to "zero" at this level.
This means that no backorders will be
cancelled.
The undershipment tolerance percent
must be blank to set this flag to "Y".
CAL-EXCL-AOC-SPRD Alpha 1 PO520 PO53.2
Exclude from AOC Exclude this line item from the
Spread Method Add On Cost Spread Methods.
CAL-PO-USER-FLD-2 Alpha 2 PO520 PO53.2
Purchase Order User Purchase order line user defined field.
Field 2
CAL-PO-USER-FLD-4 Alpha 30 (Lower Case) PO520 PO53.2
Element: User Defined FPurchase order line user defined field.
CAL-PO-USER-FLD-6 Alpha 15 (Lower Case) PO520 PO53.2
Element: User Defined FPurchase order line user defined field.
CAL-ELEMENT-01 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-02 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-03 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-04 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-05 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-06 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-07 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-08 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-09 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-ELEMENT-10 Alpha 32 PO520 PO53.2
Element: Element 01
CAL-PLI-USR-FLD-01 Alpha 20 PO520 PO53.2
Element: Pli Usr Fld 01
CAL-PLI-USR-FLD-02 Alpha 20 PO520 PO53.2
Element: Pli Usr Fld 02
CAL-PLI-USR-FLD-03 Alpha 20 PO520 PO53.2
Element: Pli Usr Fld 03
CAL-PLI-USR-FLD-04 Alpha 20 PO520 PO53.2
Element: Pli Usr Fld 04
CAL-PLI-USR-FLD-05 Alpha 20 PO520 PO53.2
Element: Pli Usr Fld 05
CAL-TAX-USAGE-CD Alpha 10 PO520 PO53.2
Element: Tax Usage Cd The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
CAL-ICN-CODE Alpha 8 PO520 PO53.2
Element: Icn Code
CAL-SUPLMNTARY-QTY Signed 13.4 PO520 PO53.2
Element: Quantity
CAL-PLI-SEG-BLOCK Alpha 103 PO520 PO53.2
Element: User Analysis
CAL-LANDED-FLAG Alpha 1 PO520 PO53.2
Element: Landed Fl This flag is set on the AOC code and
notes that the AOC will take on the
attributes on the goods line.
" " = No
1 = Landed
POCLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CALSET1 PROCURE-GROUP PO520 PO53.1
COMPANY PO53.2
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
REC-TYP
|
