Purchase Order Add On Cost Detail file. This file contains all Add On Costs
in relation to a Purchase Order. This relation can be at Purchase Order level
and/or at Purchase Order Item level.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PAO-PROCURE-GROUP
Element: 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.
|
|
PAO-COMPANY
Element: Company | Numeric 4
The company number.
|
|
PAO-VEN-AGRMT-REF
Element: Agreement Ref | Alpha 30
|
|
PAO-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
This field contains the number
representing the purchase order.
|
|
PAO-PO-RELEASE
Element: Po Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
PAO-PO-CODE
Element: Po Code | Alpha 4
This is the purchase order code.
|
|
PAO-LINE-NBR
Element: Line Nbr | Numeric 6
This field contains the line number.
|
|
PAO-AOC-CODE
Element: Aoc Code | Alpha 2
This is the identifier for the add-on
cost associated with this line item.
|
|
PAO-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The vendor's identification code.
|
|
PAO-PURCH-FR-LOC
Element: Purch Fr Loc | Alpha 4
The vendor's purchase from location.
|
|
PAO-LOCATION
Element: Location | Alpha 5
This field contains a valid stock
location within the company inventory.
|
|
PAO-AOC-RATE
Element: Aoc Rate | Percent 7.3 (Percent)
Add-on cost percentage rate. If add-on
cost is spread by rate, this value
multiplied by the line unit cost is the
unit add-on cost for the purchase order
line.
|
|
PAO-ENTRY
Element: Entry | Alpha 1
Amount entry method.
U = Unit Cost Entry
R = Rate Percentage Entry
T = Total Amount Entry |
|
PAO-QUANTITY
Element: Quantity | Signed 13.4
The order quantity.
|
|
PAO-ENT-UNIT-CST
Element: Intl Cost | Signed 18.5
The entered unit cost in the vendor
price unit of measure terms.
|
|
PAO-TOTAL-AOC
Element: Intl Amt | Signed 18.2
The total add-on cost amount can be an
entered amount if entered at this level,
or a calculated amount if a unit add-on
cost or add-on cost percent is entered.
|
|
PAO-REC-QTY
Element: Rec Qty | Signed 13.4
The quantity received against the
purchase order line the add-on cost is
associated with.
|
|
PAO-MATCHED-QTY
Element: Rec Qty | Signed 13.4
This is the total quantity to date
received for this ordered item.
|
|
PAO-MISC-MA-AMT
Element: Intl Amt | Signed 18.2
|
|
PAO-RECQTY-TO-MA
Element: Rec Qty | Signed 13.4
This is the qty on the receipt that
remains available to match. The qty in
this field would be the whole qty of the
receipt until a match is completed and
then the qty would decreas by the qty
matched. RECQTY-TO-MA - MATCHED-QTY
=new RECQTY-TO-MA
|
|
PAO-TAX-CODE
Element: Tax Code | Alpha 10
This field contains a code representing
specific tax information. This must be
valid Tax Code.
|
|
PAO-TAXABLE-FLAG
Element: Taxable Flag | Alpha 1
Defines if taxable.
Y = Yes
N = No |
|
PAO-ORIGIN-CD
Element: Origin Code | Alpha 2
System origin code
PO = Purchase Order
MA = Matching |
|
PAO-AOC-ON-PO
Element: Aoc On Po | Alpha 1
Indicates if the add-on cost is to
appear on the Purchase Order document
that is issued to the vendor.
Y = Yes
N = No |
|
PAO-SUMMARY-FLAG
Element: Summary Only | Alpha 1
Defines if the add-on cost is printed
in summary or at a detail level on the
purchase order.
Y = Yes
N = No |
|
PAO-ZERO-COST-FLG
Element: Zero Cost Flg | Alpha 1
Defines whether or not this tax record
is allowed to have a zero unit cost.
N = No
Y = Yes |
|
PAO-CANCELLED-FL
Element: All Flag | Alpha 1
N = No
Y = Yes |
|
PAO-CLOSED-FL
Element: Closed Fl | Alpha 1
The closed flag.
N = No
Y = Yes
H = History |
|
PAO-INV-SPRD-CRET
Element: Inv Sprd Cret | Numeric 1
Defines if record was created during
purchase order invoice spread.
1 = Invoice Spread Difference |
|
PAO-MATCH-DTL-KEY
Element: Match Dtl Key | Alpha 85
|
|
PAO-ISSUED-FLAG
Element: All Flag | Alpha 1
This is the issue status of the add on
cost detail record. If the PO has been
issued at least once since the add on
cost detail record was created, this
flag will be set to a value of "Y".
Once set to "Y", it never changes.
Y = Issued
N = Not Issued |
|
PAO-INVC-TAX-AMT
Element: Intl Amt | Signed 18.2
|
|
PAO-ACCR-TAX-AMT
Element: Intl Amt | Signed 18.2
|
|
PAO-EXT-TAXBL-AMT
Element: Intl Amt | Signed 18.2
The amount of the add on cost that is
taxable. This is zero if the taxable
flag is "N", otherwise it will equal the
total AOC amount.
|
|
PAO-LAND-UNIT-CST
Element: Intl Cost | Signed 18.5
The unit cost of the add on costs if it
is landed in addition to the unit cost
of taxes that are landed.
|
|
PAO-BL-INVC-AMT
Element: Intl Amt | Signed 18.2
|
|
PAO-LANDED-FLAG
Element: Landed Flag | Numeric 1
0 = No
1 = Landed |
|
PAO-FREIGHT-TERMS
Element: Freight Terms | Alpha 1
Freight terms are used to define who
pays for freight costs incurred when
goods are shipped. Prepaid, for
instance, would normally mean that the
vendor would pay for freight. Collect
would mean the customer would pay for
freight.
A freight terms code can be entered on
a purchase order, or defaulted by vendor
or company.
|
|
PAO-FOB-CODE
Element: Fob Code | Alpha 3
The user defined Free On Board Code.
|
|
PAO-TERM-CODE
Element: Term Code | Alpha 5
A user-defined code representing a
method of determining invoice due and
discount dates.
|
|
PAO-XREF-VENDOR
Element: Xref Vendor | Alpha 9 (Right Justified)
This is a vendor that is supported on a
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.
|
|
PAO-CURRENCY-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
PAO-ENT-CNV-RATE
Element: Ent Cnv Rate | Signed 14.7
Currency conversion rate at Purchase
Order entry time.
|
|
PAO-REC-CNV-RATE
Element: Ent Cnv Rate | Signed 14.7
Currency conversion rate at Purchase
Order entry time.
|
|
PAO-TOTAL-AOC-PO
Element: Intl Amt | Signed 18.2
The total add-on cost amount in the
Purchase Order currency.
|
|
PAO-OPEN-PO-AMT
Element: Intl Amt | Signed 18.2
|
|
PAO-CHARGEBACK-QTY
Element: Quantity | Signed 13.4
This field contains the desired
quantity.
|
|
PAO-ITAX-AMT-PO
Element: Intl Amt | Signed 18.2
|
|
PAO-ATAX-AMT-PO
Element: Intl Amt | Signed 18.2
|
|
PAO-EX-TXBL-AMT-PO
Element: Intl Amt | Signed 18.2
|
|
PAO-MNR-QTY
Element: Quantity | Signed 13.4
|
|
PAO-WRITE-OFF-QTY
Element: Quantity | Signed 13.4
|
|
PAO-ARCHIVE-QTY
Element: Quantity | Signed 13.4
|
|
PAO-MEMO-QTY
Element: Quantity | Signed 13.4
|
|
PAO-MEMO-AMT
Element: Intl Amt | Signed 18.2
|
|
PAO-TRACK-TYPE
Element: Aoc Type | Alpha 1
" " = Other AOC
I = Insurance
F = Freight
C = Customs Charges |
|
PAO-GLBL-DOC-TYPE
Element: Glbl Doc Type | Alpha 10
|
|
PAO-GLBL-LINE-TYPE
Element: Glbl Line Type | Alpha 15
|
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| PAOSET1 |
COMPANY
PROCURE-GROUP
VEN-AGRMT-REF
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
|
|
|
| PAOSET10 |
COMPANY
PROCURE-GROUP
VEN-AGRMT-REF
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
VENDOR
|
|
|
| PAOSET2 |
COMPANY
AOC-CODE
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
|
|
Subset |
| Where | | VEN-AGRMT-REF |
= | Spaces | |
|
|
| PAOSET3 |
COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
|
|
Subset |
| Where | | LINE-NBR |
!= | Zeroes | |
| And | | VEN-AGRMT-REF |
= | Spaces | |
|
|
| PAOSET4 |
COMPANY
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
AOC-CODE
LINE-NBR
|
|
KeyChange, Subset |
| Where | | CLOSED-FL |
= | "N" | |
| And | | CANCELLED-FL |
= | "N" | |
| And | | VEN-AGRMT-REF |
= | Spaces | |
|
|
| PAOSET5 |
COMPANY
AOC-CODE
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
|
|
Subset |
| Where | | CLOSED-FL |
= | "N" | |
| And | | CANCELLED-FL |
= | "N" | |
| And | | VEN-AGRMT-REF |
= | Spaces | |
|
|
| PAOSET6 |
PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
AOC-CODE
|
|
Subset |
| Where | | VEN-AGRMT-REF |
!= | Spaces | |
|
|
| PAOSET8 |
COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
MATCH-DTL-KEY
LINE-NBR
AOC-CODE
|
|
KeyChange, Subset |
| Where | | VEN-AGRMT-REF |
= | Spaces | |
|
|
| PAOSET9 |
COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
AOC-ON-PO
VENDOR
LINE-NBR
AOC-CODE
|
|
KeyChange, Subset |
| Where | | CANCELLED-FL |
!= | "Y" | |
| And | | VEN-AGRMT-REF |
= | Spaces | |
|
|
