POVACOMMIX

UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVX-PROCURE-GROUP
Element: Procure Group		Alpha 4
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-VEN-AGRMT-REF
Element: Ven Agrmt Ref		Alpha 30
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-LINE-NBR
Element: Line Nbr		Numeric 6
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-SYSTEM
Element: System		Alpha 2
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-LINE-SEQ
Element: Seq		Numeric 3
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-PERIOD
Element: Period		Numeric 2
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-COMMITMENT-DTE
Element: Date		Numeric 8 (yyyymmdd)
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-COMPANY
Element: Company		Numeric 4
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-PO-CODE
Element: Po Code		Alpha 4
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-PO-RELEASE
Element: Po Release		Numeric 4
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-PO-LINE-NBR
Element: Line Nbr		Numeric 6
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-REQ-NUMBER
Element: Req Number		Numeric 7
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-REQ-LINE-NBR
Element: Line Nbr		Numeric 6
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-SPT-OBJ-ID
Element: Obj Id		Numeric 12
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-TRAN-AMOUNT
Element: Intl Amt		Signed 18.2
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-CURRENCY-CODE
Element: Currency Code		Alpha 5
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-SPREAD-DATE
Element: Date		Numeric 8 (yyyymmdd)
This is the date of the commitment spread record.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-RETURN-NUMBER
Element: Return Number		Numeric 10
This is filled in with the return number if this record is built from the vendor returns program.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVX-RET-LINE-NBR
Element: Line Nbr		Numeric 6
This is the line number of the vendor return for which this record is being built if this record is for a vendor return.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1


POVACOMMIX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVXSET1 PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
SYSTEM
LINE-SEQ
SPREAD-DATE
SPT-OBJ-ID
PVXSET2 SPT-OBJ-ID
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


POVACOMMIX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Poline POLINE Required
When (PVX-PO-NUMBER !=Spaces )
PVX-COMPANY->PLI-COMPANY
PVX-PO-NUMBER->PLI-PO-NUMBER
PVX-PO-RELEASE->PLI-PO-RELEASE
PVX-PO-CODE->PLI-PO-CODE
PVX-PO-LINE-NBR->PLI-LINE-NBR
Poreturnln PORETURNLN Required
When (PVX-RETURN-NUMBER !=Zeroes )
PVX-COMPANY->PTL-COMPANY
PVX-RETURN-NUMBER->PTL-RETURN-NUMBER
PVX-RET-LINE-NBR->PTL-RET-LINE-NBR
Reqline REQLINE Required
When (PVX-REQ-NUMBER !=Zeroes )
PVX-COMPANY->RLN-COMPANY
PVX-REQ-NUMBER->RLN-REQ-NUMBER
PVX-REQ-LINE-NBR->RLN-LINE-NBR

File created: Wed Jun 08 20:50:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.