POINVOICE FILE
Invoice Master
This file contains header information for a purchase order invoice.
REFERENCED BY
BL92.1 MA52.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 PO122 PO20.1
PO21.3 PO21.5 PO22.2 PO22.3 PO30.1 PO34.1
PO35.1 PO52.1 PO530 RQ10.1 RQ10.2 WH20.2
WH20.7
UPDATED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 MA140 MA300 MA40.1 MA41.1 MA41.2
MA41.4 MA41.6 MA41.5 MA43.1 MA43.2 MA43.4
MA530 MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POI-COMPANY Numeric 4 MA40.1 MA41.1
Company The company number. MA41.2 MA41.4
MA43.1 MA43.2
MA43.4 MA530
MA540 PO31.1
POI-PO-NUMBER Alpha 7 (Right Justified) AP125 AP126
PO Number This field contains the number AP225 AP226
representing the purchase order. AP25.1 AP25.2
AP26.1 MA40.1
MA41.1 MA41.2
MA41.4 MA43.1
MA43.2 MA43.4
MA530 MA540
PO31.1
POI-PO-RELEASE Numeric 6 AP125 AP126
PO Release Number Used to identify a purchase order AP225 AP226
release (created from a Blanket or AP25.1 AP25.2
Standing order). AP26.1 MA40.1
MA41.1 MA41.2
MA41.4 MA43.1
MA43.2 MA43.4
MA530 MA540
PO31.1
POI-VENDOR Alpha 9 MA40.1 MA41.1
Vendor ID The vendor's identification code. MA41.2 MA41.4
MA43.1 MA43.2
MA43.4 MA530
MA540 PO31.1
POI-INVOICE Alpha 22 MA40.1 MA41.1
Invoice Number Used to identify the invoice. MA41.2 MA41.4
MA43.1 MA43.2
MA43.4 MA530
MA540 PO31.1
POI-SUFFIX Numeric 3 MA41.1 MA43.1
Invoice Suffix This is the suffix for the invoice. MA530 MA540
PO31.1
POI-INVOICE-TYPE Alpha 1 AP125 AP126
Invoice Type The invoice type. AP225 AP226
R = Regular AP25.1 AP25.2
D = Debit Memo AP26.1 MA40.1
C = Credit Memo MA41.4 MA43.4
MA530 MA540
PO31.1
POI-TAX-CODE Alpha 10 MA40.1 MA41.4
Tax Code This field contains a code representing MA43.4
specific tax information. This must be
valid Tax Code.
POI-TAX-CODE-CNTL Alpha 1 MA40.1 MA43.4
Tax Adjustment Code This control field defines the tax code
usage in invoicing and approving taxes.
For purchase order invoices, if set to
O (Override) all lines approved for
payment will use the tax code defined
for the whole invoice.
If set to I (Ignore), no purchase order
lines approved for payment will be
taxed.
O = Override Tax Code
C = Calculate Tax Code Amounts
I = Ignore Tax Codes
POI-CURRENCY-CODE Alpha 5 AP125 AP126
Currency Code The base currency defined for the AP225 AP226
company in the General Ledger system. AP25.1 AP25.2
AP26.1 MA40.1
MA41.4 MA43.4
MA530 MA540
PO31.1
POI-INV-CNV-RATE Signed 12.6 AP125 AP126
Invoice Exchange Currency conversion rate for the AP225 AP226
Rate purchase order at invoicing time. AP25.1 AP25.2
AP26.1 MA40.1
MA41.4 MA43.4
MA530 MA540
PO31.1
POI-CURRENCY-FLAG Alpha 1 AP125 AP126
Currency Flag Conversion Method for Currency - AP225 AP226
Multiply/Divide. AP25.1 AP25.2
M = Multiply AP26.1 MA40.1
D = Divide MA530 MA540
PO31.1
POI-REVALUE-FLAG Alpha 1 MA40.1 MA41.4
Revalue Currency will be re-evaluated when MA43.4 MA530
Accounts Payable prints check in a MA540 PO31.1
currency other than established on the
purchase order/invoice.
Y = Yes
N = No
POI-NBR-PEND-LINE Numeric 4 MA41.1 MA41.2
Number of Pending Number of approval lines defined as MA43.1 MA43.2
Lines Pend Hold for Accounts Payable. These MA52.1 MA530
are items that are being pre-paid, MA540 PO31.1
Invoiced but not Received.
POI-OPER-ID Alpha 10 MA40.1 MA41.4
Operator This defines the identification of the MA43.4 MA530
Identification entry user. MA540 PO31.1
POI-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
POI-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
POI-PROCESS-LEVEL Alpha 5 AP125 AP126
Process Level This field contains the process level, AP225 AP226
which is the reporting hierarchy below AP25.1 AP25.2
company. AP26.1 MA40.1
MA41.4 MA43.4
MA530 MA540
PO31.1
POI-STATUS Numeric 1 AP125 AP126
Status The current status of the invoice. AP225 AP226
0 = Unreleased AP25.1 AP25.2
1 = Released AP26.1 MA140
2 = Logged MA530 MA540
PO31.1
POINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POISET1 COMPANY BL92.1 MA300
PO-NUMBER MA40.1 MA40.2
PO-RELEASE MA41.1 MA41.2
VENDOR MA41.3 MA41.5
INVOICE MA41.6 MA43.1
SUFFIX MA43.2 MA43.3
MA52.1 MA530
MA540 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
...
POISET2 COMPANY AP125 AP126
VENDOR AP225 AP226
INVOICE AP25.1 AP25.2
SUFFIX AP26.1 MA140
PO-NUMBER MA40.1 MA40.2
PO-RELEASE MA41.1 MA41.2
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 PO30.1
PO31.1 PO34.1
...
POINVOICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apbatch APBATCH Not Required
POI-COMPANY -> APB-COMPANY
API-BATCH-NUM -> APB-BATCH-NUM
Apcompany APCOMPANY Required
POI-COMPANY -> CPY-COMPANY
Apinvoice APINVOICE Required
POI-COMPANY -> API-COMPANY
POI-VENDOR -> API-VENDOR
POI-INVOICE -> API-INVOICE
POI-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Iccompany ICCOMPANY Required
POI-COMPANY -> ICC-COMPANY
Pocompany POCOMPANY Required
POI-COMPANY -> PCY-COMPANY
Purchorder PURCHORDER Required
POI-COMPANY -> PCR-COMPANY
POI-PO-NUMBER -> PCR-PO-NUMBER
POI-PO-RELEASE -> PCR-PO-RELEASE
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
POI-VENDOR -> VEN-VENDOR
Vendorloc APVENLOC Not Required
Valid When POI-PURCH-FR-LOC != Spaces
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
POI-VENDOR -> VLO-VENDOR
PCR-PURCH-FR-LOC -> VLO-LOCATION-CODE
POINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hdrcomments POCOMMENTS
POI-COMPANY -> POC-COMPANY
Spaces -> POC-ORDER-NAME
Zeroes -> POC-RETURN-NUMBER
POI-PO-NUMBER -> POC-PO-NUMBER
POI-PO-RELEASE -> POC-PO-RELEASE
Zeroes -> POC-LINE-NBR
POC-SEQ
Poaocdtl POAOCDTL
POI-COMPANY -> PAO-COMPANY
Spaces -> PAO-ORDER-NAME
POI-PO-NUMBER -> PAO-PO-NUMBER
POI-PO-RELEASE -> PAO-PO-RELEASE
PAO-LINE-NBR
PAO-AOC-CODE
Poaochdrdtl POAOCDTL
POI-COMPANY -> PAO-COMPANY
Spaces -> PAO-ORDER-NAME
POI-PO-NUMBER -> PAO-PO-NUMBER
POI-PO-RELEASE -> PAO-PO-RELEASE
Zeroes -> PAO-LINE-NBR
PAO-AOC-CODE
Poaocsprd POAOCSPRD Delete Cascades
POI-COMPANY -> PSP-COMPANY
POI-INVOICE -> PSP-INVOICE
PSP-AOC-CODE
PSP-PO-NUMBER
PSP-PO-RELEASE
PSP-SPREAD-TYPE
Poapprove POAPPROVE Delete Cascades
POI-COMPANY -> POA-COMPANY
POI-VENDOR -> POA-VENDOR
POI-INVOICE -> POA-INVOICE
POI-SUFFIX -> POA-SUFFIX
POI-PO-NUMBER -> POA-PO-NUMBER
POI-PO-RELEASE -> POA-PO-RELEASE
POA-LINE-NBR
POA-AOC-CODE
Poline POLINE
POI-COMPANY -> PLI-COMPANY
POI-PO-NUMBER -> PLI-PO-NUMBER
POI-PO-RELEASE -> PLI-PO-RELEASE
PLI-LINE-NBR
Trlcomments POCOMMENTS
POI-COMPANY -> POC-COMPANY
Spaces -> POC-ORDER-NAME
Zeroes -> POC-RETURN-NUMBER
POI-PO-NUMBER -> POC-PO-NUMBER
POI-PO-RELEASE -> POC-PO-RELEASE
999999 -> POC-LINE-NBR
POC-SEQ
|