|
|
POCAOCDTL FILE
UPDATED BY
PO520 PO53.4 PO53.8 PO53.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAO-PROCURE-GROUP Alpha 4 PO520 PO53.4
Element: Procure Group This field contains the identifier for a PO53.8
group of companies that share a common
procurement effort. They buy items and
services together.
CAO-COMPANY Numeric 4 PO520 PO53.4
Element: Company Identifies the AP company if the PO53.8
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
CAO-PO-NUMBER Alpha 14 (Right Justified) PO520 PO53.4
Element: PO Number This field contains the number PO53.8
representing the purchase order.
CAO-PO-RELEASE Numeric 4 PO520 PO53.4
Element: PO Release NumUsed to identify a purchase order PO53.8
release (created from a Blanket or
Standing order).
CAO-PO-CODE Alpha 4 PO520 PO53.4
Element: Po Code This is the purchase order code. PO53.8
CAO-LINE-NBR Numeric 6 PO520 PO53.4
Element: Line Number This field contains the line number. PO53.8
CAO-AOC-CODE Alpha 2 PO520 PO53.4
Element: Add On Cost CoThis field contains the identifier for PO53.8
the add on cost associated with this
line item.
CAO-REC-TYP Numeric 2 PO520 PO53.4
Element: Rec Typ PO53.8
CAO-VENDOR Alpha 9 (Right Justified) PO520 PO53.4
Element: Vendor ID The vendor's identification code. PO53.8
CAO-PURCH-FR-LOC Alpha 4 PO520 PO53.4
Purchase From The vendor's purchase from location. PO53.8
Location Code
CAO-AOC-RATE Percent 7.3 (Percent) PO520 PO53.4
Element: Add On Cost RaAdd On Cost Percentage Rate. If add on PO53.8
cost is spread by rate, this value times
the line unit cost is the unit add on
cost for the PO line.
CAO-ENTRY Alpha 1 PO520 PO53.4
Element: Entry Amount Entry Method. PO53.8
U = Unit Cost Entry
R = Rate Percentage Entry
T = Total Amount Entry
CAO-QUANTITY Signed 13.4 PO520 PO53.4
Element: Quantity This field contains the desired PO53.8
quantity.
CAO-ENT-UNIT-CST Signed 18.5 PO520 PO53.4
Element: Intl Cost The entered unit cost. PO53.8
CAO-TOTAL-AOC Signed 18.2 PO520 PO53.4
Element: Intl Amt The total add on cost amount can be an PO53.8
entered amount if entered at this
level, or a calculated amount if a unit
add on cost or add on cost percent is
entered.
CAO-TAX-CODE Alpha 10 PO520 PO53.4
Element: Tax Code This field contains a code representing PO53.8
specific tax information. This must be
valid Tax Code.
CAO-TAXABLE-FLAG Alpha 1 PO520 PO53.4
Taxable or Defines if Taxable. PO53.8
Non-Taxable Flag Y = Yes
N = No
CAO-AOC-ON-PO Alpha 1 PO520 PO53.4
Element: Aoc On Po Indicates if the add-on cost is to PO53.8
appear on the Purchase Order document
that is issued to the vendor.
Y = Yes
N = No
CAO-SUMMARY-FLAG Alpha 1 PO520 PO53.4
Element: Summary Flag Defines if add on cost is printed in PO53.8
summary or at a detail level on the
Lawson Purchase Order document.
Y = Yes
N = No
CAO-ZERO-COST-FLG Alpha 1 PO520 PO53.4
Element: Zero Cost FlagDefines if this tax record is allowed PO53.8
to have a zero unit cost.
N = No
Y = Yes
CAO-CLOSED-FL Alpha 1 PO520 PO53.4
Element: Closed Flag The Closed Flag. PO53.8
N = No
Y = Yes
CAO-LANDED-FL Alpha 1 PO520 PO53.4
Element: Landed Fl This flag will denote if the AOC of PO53.8
record is landed or not landed. Landed
means the AOC takes on the
characteristics of the goods it is
landed to.
0 = No
1 = Landed
CAO-XREF-VENDOR Alpha 9 (Right Justified) PO520 PO53.4
Element: Xref Vendor This is a vendor that is supported on a PO53.8
system outside Lawson. When records are
interfaces we will maintain this vendor
on the file but we will use the Lawson
vendor while in the lawson application.
CAO-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
CAO-ENT-CNV-RATE Signed 14.7
Entered Conversion Currency conversion rate at Purchase
Rate Order entry time.
CAO-REC-CNV-RATE Signed 14.7
Entered Conversion Currency conversion rate for the
Rate Purchase Order at receiving time.
CAO-TOTAL-AOC-PO Signed 18.2
Element: Intl Amt
CAO-OPEN-PO-AMT Signed 18.2
Element: Intl Amt The portion of the total or extended
ordered amount that is still open --
that is, it has not been cancelled or
paid. This is always expressed in the
company base currency, and includes only
product costs (add on costs and taxes
are not included).
POCAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAOSET1 PROCURE-GROUP PO520 PO53.1
COMPANY PO53.4 PO53.8
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
REC-TYP
|
