POAPPROVE FILE
Invoice Approvals
This file contains Purchase Order line item, miscellaneous add on cost, and
line item add on cost approval information by invoice and purchase order.
REFERENCED BY
MA140 PO122 PO20.1 PO21.3 PO21.5 PO21.6
PO22.2 PO22.3 PO25.1 PO30.1 PO34.1 PO35.1
PO52.1 PO530 RQ10.1 RQ10.2 BL92.1 IN20.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510
OE810 OE920 RQ20.1 RQ20.3 RQ20.4 WH20.2
WH20.7 MA278 PO64.1 PO135 PO236 PO295
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP25.3 AP26.1 MA300 MA40.1 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1 MA530 MA540 PO31.1 PO962
PO981 PO991
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POA-COMPANY Numeric 4 MA40.1 MA41.1
Company The company number. MA41.2 MA41.5
MA41.6 MA43.1
MA43.2 MA530
MA540 PO31.1
PO962
POA-VENDOR Alpha 9 MA40.1 MA41.1
Vendor ID The vendor's identification code. MA41.2 MA41.5
MA41.6 MA43.1
MA43.2 MA530
MA540 PO31.1
PO962
POA-INVOICE Alpha 22 MA40.1 MA41.1
Invoice Number Used to identify the invoice. MA41.2 MA41.5
MA41.6 MA43.1
MA43.2 MA530
MA540 PO31.1
PO962
POA-SUFFIX Numeric 3 MA40.1 MA41.1
Invoice Suffix This is the suffix for the invoice. MA41.5 MA41.6
MA43.1 PO962
POA-PO-NUMBER Alpha 7 (Right Justified) MA40.1 MA41.1
PO Number This field contains the number MA41.2 MA41.5
representing the purchase order. MA41.6 MA43.1
MA43.2 MA530
MA540 PO31.1
PO962
POA-PO-RELEASE Numeric 6 MA40.1 MA41.1
PO Release Number Used to identify a purchase order MA41.2 MA41.5
release (created from a Blanket or MA41.6 MA43.1
Standing order). MA43.2 MA530
MA540 PO31.1
PO962
POA-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP225 AP226
AP25.1 AP25.2
AP26.1 MA40.1
MA41.1 MA41.2
MA41.5 MA41.6
MA43.1 MA43.2
MA530 MA540
PO31.1 PO962
POA-AOC-CODE Alpha 2 AP125 AP126
Add On Cost Code This field contains the identifier for AP225 AP226
the add-on cost associated with this AP25.1 AP25.2
line item. AP26.1 MA40.1
MA41.1 MA41.2
MA41.5 MA41.6
MA43.1 MA530
MA540 PO31.1
PO962
POA-OPER-ID Alpha 10 MA40.1 MA41.1
Operator This is a unique identifier that MA41.2 MA41.5
Identification defines the entry user. MA41.6 MA43.1
MA43.2 MA530
MA540 PO31.1
PO962
POA-ITEM-TYPE Alpha 1 MA40.1 MA41.1
Item Type This field identifies the line item MA41.2 MA41.6
type. MA43.1 MA43.2
I = INVENTORY MA530 MA540
N = NON-STOCK PO31.1 PO962
S = SERVICE
X = SPECIAL
POA-ITEM Alpha 32 MA40.1 MA41.1
Item Number This field contains the item MA41.2 MA41.6
identifier. MA43.1 MA43.2
MA530 MA540
PO31.1 PO962
POA-APPROVE-QTY Signed 13.4 AP25.1 AP25.2
Approved Quantity The total approved quantity for this MA40.1 MA41.1
line item. MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.4 MA52.1
MA530 MA540
PO31.1 PO962
POA-ENT-UNIT-CST Signed 13.5 MA40.1 MA41.1
Entered Unit Cost The entered unit cost. MA41.2 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA52.1 MA530
MA540 PO31.1
PO962
POA-COST-ADJ-FL Alpha 1 MA40.1 MA41.1
Cost Adjustment Flag Not in use. MA41.2 MA41.5
N = No MA41.6 MA43.1
Y = Yes MA43.2 MA530
MA540 PO31.1
PO962
POA-BATCH-NBR Numeric 6 AP25.3 MA40.1
Batch Number This identifies the batch the entered MA41.1 MA41.2
invoices, debit memos, and credit memos MA41.5 MA41.6
are a part of. MA43.1 MA43.2
MA530 MA540
PO31.1 PO962
POA-DIST-DATE Numeric 8 (yyyymmdd) AP125 AP126
Posting Date The general ledger posting date that AP225 AP226
the general ledger transactions created AP25.1 AP25.2
for this record will use. AP26.1 MA530
MA540 PO31.1
PO962
POA-TAX-CODE Alpha 10 MA40.1 MA41.1
Tax Code This field contains a code representing MA41.2 MA41.5
specific tax information. This must be MA41.6 MA43.1
valid Tax Code. MA43.2 MA530
MA540 PO31.1
PO962
POA-TAX-AMOUNT Signed 13.5 MA40.1 MA41.1
Tax Amount This field contains the total tax MA41.2 MA41.4
amount on the approval record. MA41.5 MA41.6
MA43.1 MA43.2
MA43.4 MA52.1
MA530 MA540
PO31.1 PO962
PO981 PO991
POA-TOT-DIST-AMT Signed 15.2 AP25.1 AP25.2
Total Distributed Total amount distributed to this line MA40.1 MA41.1
Amount item. MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
PO962
POA-TOT-BASE-AMT Signed 15.2 MA40.1 MA41.1
Total Base Amount This defines the total distributed MA41.2 MA41.4
approval amount in the company base MA41.5 MA41.6
currency. MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
PO962
POA-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Update Date This field contains the date the record AP225 AP226
was updated. AP25.1 AP25.2
AP26.1 MA530
MA540 PO31.1
PO962
POA-UPDATE-TIME Numeric 6 AP125 AP126
Update Time This field contains the system time AP225 AP226
when the record was updated. AP25.1 AP25.2
AP26.1 MA530
MA540 PO31.1
PO962
POA-STATUS Numeric 1 AP125 AP126
Status This flag defines the current status of AP225 AP226
the invoice approval line item. AP25.1 AP25.2
0 = Entered AP26.1 MA43.1
1 = Approved MA43.2 MA43.3
4 = Tolerance Error MA52.1 MA530
MA540 PO31.1
PO962
POA-VBUY-APPR-QTY Signed 13.4 MA40.1 MA41.1
Vendor Buy Approved The approved quantity converted to the MA41.2 MA41.4
Quantity vendor buy unit of measure. MA43.1 MA43.2
MA43.4 MA52.1
MA530 MA540
PO31.1 PO962
POA-NO-TAX-FLAG Alpha 1 MA41.2 MA43.2
No Tax Flag Ignore the tax code if set to Yes. PO962
Y = Yes
POA-LINE-LOCATION Derived
Line Location
POA-VEND-PURCH-FR Derived
Vendor Purchase From
POAPPROVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POASET1 COMPANY AP125 AP126
VENDOR AP225 AP226
INVOICE AP25.1 AP25.2
SUFFIX AP25.3 AP26.1
PO-NUMBER MA140 MA300
PO-RELEASE MA40.1 MA40.2
LINE-NBR MA41.1 MA41.2
AOC-CODE MA41.3 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO122
PO20.1 PO21.3
PO22.2 PO22.3
...
POASET2 COMPANY BL92.1 IN20.1
PO-NUMBER OE10.1 OE10.2
PO-RELEASE OE10.3 OE10.4
LINE-NBR OE10.5 OE10.6
VENDOR OE10.7 OE10.8
INVOICE OE11.1 OE11.4
SUFFIX OE11.8 OE11.9
AOC-CODE OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 PO21.5
...
POASET3 COMPANY KeyChange, Subset MA278 PO64.1
PO-NUMBER Where STATUS > Zeroes
PO-RELEASE And STATUS != 4
LINE-NBR
UPDATE-DATE
UPDATE-TIME
VENDOR
INVOICE
SUFFIX
AOC-CODE
POASET4 COMPANY KeyChange, Subset PO135 PO236
PO-NUMBER Where STATUS > Zeroes
PO-RELEASE
LINE-NBR
DIST-DATE
VENDOR
INVOICE
SUFFIX
AOC-CODE
POASET5 COMPANY Subset
BATCH-NBR Where STATUS = Zeroes
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
LINE-NBR
AOC-CODE
POASET6 COMPANY BL92.1 IN20.1
PO-NUMBER MA40.1 MA41.1
PO-RELEASE MA41.2 MA43.1
LINE-NBR MA43.2 MA52.1
VENDOR MA530 MA540
AOC-CODE OE10.1 OE10.2
INVOICE OE10.3 OE10.4
SUFFIX OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
...
POAPPROVE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apbatch APBATCH Required
API-COMPANY -> APB-COMPANY
API-BATCH-NUM -> APB-BATCH-NUM
Apcompany APCOMPANY Required
POA-COMPANY -> CPY-COMPANY
Apinvoice APINVOICE Required
POA-COMPANY -> API-COMPANY
POA-VENDOR -> API-VENDOR
POA-INVOICE -> API-INVOICE
POA-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Buyer BUYER Required
POA-COMPANY -> BUY-COMPANY
PLI-BUYER-CODE -> BUY-BUYER-CODE
Iccompany ICCOMPANY Required
POA-COMPANY -> ICC-COMPANY
Itemloc ITEMLOC Required
When POA-ITEM-TYPE = "I"
POA-COMPANY -> ITL-COMPANY
PLI-LOCATION -> ITL-LOCATION
POA-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When POA-ITEM-TYPE = "I"
Or POA-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
POA-ITEM -> ITE-ITEM
Location ICLOCATION Required
POA-COMPANY -> ICL-COMPANY
PLI-LOCATION -> ICL-LOCATION
Poaocdtl POAOCDTL Required
When POA-AOC-CODE != Spaces
POA-COMPANY -> PAO-COMPANY
Spaces -> PAO-ORDER-NAME
POA-PO-NUMBER -> PAO-PO-NUMBER
POA-PO-RELEASE -> PAO-PO-RELEASE
POA-LINE-NBR -> PAO-LINE-NBR
POA-AOC-CODE -> PAO-AOC-CODE
Poaocmast POAOCMAST Required
When POA-AOC-CODE != Spaces
POA-COMPANY -> PAM-COMPANY
POA-AOC-CODE -> PAM-AOC-CODE
Pocompany POCOMPANY Required
POA-COMPANY -> PCY-COMPANY
Poinvoice POINVOICE Required
POA-COMPANY -> POI-COMPANY
POA-PO-NUMBER -> POI-PO-NUMBER
POA-PO-RELEASE -> POI-PO-RELEASE
POA-VENDOR -> POI-VENDOR
POA-INVOICE -> POI-INVOICE
POA-SUFFIX -> POI-SUFFIX
Poline POLINE Required
POA-COMPANY -> PLI-COMPANY
POA-PO-NUMBER -> PLI-PO-NUMBER
POA-PO-RELEASE -> PLI-PO-RELEASE
POA-LINE-NBR -> PLI-LINE-NBR
Poquotes POQUOTES Not Required
POA-COMPANY -> POQ-COMPANY
POA-ITEM -> POQ-ITEM
POA-VENDOR -> POQ-VENDOR
POA-LINE-LOCATION -> POQ-LOCATION
POA-VEND-PURCH-FR -> POQ-PURCH-FR-LOC
Purchorder PURCHORDER Required
POA-COMPANY -> PCR-COMPANY
POA-PO-NUMBER -> PCR-PO-NUMBER
POA-PO-RELEASE -> PCR-PO-RELEASE
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
POA-VENDOR -> VEN-VENDOR
POAPPROVE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apdistrib APDISTRIB Delete Cascades
POA-COMPANY -> APD-COMPANY
POA-PO-NUMBER -> APD-PO-NUM
POA-PO-RELEASE -> APD-PO-RELEASE
POA-LINE-NBR -> APD-PO-LINE-NBR
POA-AOC-CODE -> APD-PO-AOC-CODE
API-OBJ-ID -> APD-API-OBJ-ID
APD-DIST-SEQ-NBR
Mmdist MMDIST Delete Cascades
Valid When POA-ITEM-TYPE != "I"
POA-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
Spaces -> MMD-LOCATION
"P" -> MMD-DOC-TYPE
POA-PO-NUMBER -> MMD-DOC-NBR
POA-PO-RELEASE -> MMD-DOC-NBR-NUM
POA-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
POA-AOC-CODE -> MMD-AOC-CODE
MMD-LINE-SEQ
Porecline PORECLINE
POA-COMPANY -> PRL-COMPANY
POA-PO-NUMBER -> PRL-PO-NUMBER
POA-PO-RELEASE -> PRL-PO-RELEASE
POA-LINE-NBR -> PRL-PO-LINE-NBR
PRL-DOC-TYPE
PRL-DOCUMENT
PRL-LINE-NBR
|