|
|
BUYER FILE
PO Buyer Master
A file of valid buyers. Contains default and control information.
REFERENCED BY
AP06.1 AP205 IC130 MA236 MA264 MA64.1
MA64.2 MA64.3 MA64.5 MA64.6 MA69.1 PO00.1
PO130 PO133 PO135 PO136 PO139 PO190
PO223 PO254 PO258 PO26.1 PO278 PO54.1
PO54.2 PO54.3 PO54.4 PO58.1 PO58.2 PO64.1
POA2.2 POAB.1 POI7.1 RQIA.1 RQIC.1 RQID.1
RQIG.1 MX223 PO285
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 AP510 API1.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
IC12.1 IC330 MX500 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.7 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO15.1
PO15.2 PO150 PO20.1 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO27.2
PO275 PO276 PO277 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POBL.1 POI3.1 POID.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BUY-PROCURE-GROUP Alpha 4 AP125 AP126
Element: Procure Group This field contains the identifier for AP131 AP20.1
a group of companies that share a common AP20.2 AP20.3
procurement effort. They buy items and AP20.4 AP20.5
services together. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer The user-defined buyer identifier. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-OPERATOR-ID Alpha 10 AP125 AP126
Element: Operator This field is used to store the login AP131 AP20.1
id of the person who entered the record. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-BUYER-GRP Alpha 5 AP125 AP126
Element: Buyer Grp The buyer's buyer group code. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-NAME Alpha 30 (Lower Case) AP125 AP126
Element: Name The buyer's name. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-ADDR1 Alpha 30 (Lower Case) AP125 AP126
Element: Addr1 The buyer's first line of address AP131 AP20.1
information. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-ADDR2 Alpha 30 (Lower Case) AP125 AP126
Element: Addr1 The buyer's second line of address AP131 AP20.1
information. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-ADDR3 Alpha 30 (Lower Case) AP125 AP126
Element: Addr1 The buyer's third line of address AP131 AP20.1
information. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-ADDR4 Alpha 30 (Lower Case) AP125 AP126
Element: Addr1 The buyer's fourth line of address AP131 AP20.1
information. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-CITY-ADDR5 Alpha 18 (Lower Case) AP125 AP126
Element: City This is the buyer's city or the fifth AP131 AP20.1
line of address information. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-STATE-PROV Alpha 2 AP125 AP126
Element: State Prov This is the buyer's state or province. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-POSTAL-CODE Alpha 10 (Lower Case) AP125 AP126
Element: Postal Code This is the buyer's mail code. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-COUNTRY Alpha 30 (Lower Case) AP125 AP126
Element: Country This field contains the country of the AP131 AP20.1
address, or it can be used for AP20.2 AP20.3
additional information such as an AP20.4 AP20.5
attention name. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-PHONE-PREFIX Alpha 6 AP125 AP126
Element: Phone Prefix The buyer's telephone prefix. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-PHONE Alpha 15 AP125 AP126
Element: Phone The buyer's telephone number. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-PHONE-EXT Alpha 5 AP125 AP126
Element: Phone Ext The buyer's telephone extension number. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-PO-LIMIT Signed 18.2 AP125 AP126
Element: Limit Per PO The buyer's per purchase order amount AP131 AP20.1
limit. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-ACTIVE-STATUS Alpha 1 AP125 AP126
Element: Active Status The status of the account. If Inactive, AP131 AP20.1
no posting can be done to the account. AP20.2 AP20.3
A = Active AP20.4 AP20.5
I = Inactive AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-CLASS-ONLY-FL Alpha 1 AP125 AP126
Element: Class Only Fl Y = Yes AP131 AP20.1
N = No AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-BUYER-CODE Alpha 1 AP125 AP126
Element: Fil Buyer CodeY = Yes 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-BUY-PUR-CL Alpha 1 AP125 AP126
Element: Fil Buy Pur ClY = Yes 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-BUY-VEN-FL Alpha 1 AP125 AP126
Element: Fil Buy Ven FlY = Yes 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-BUY-LOC-FL Alpha 1 AP125 AP126
Element: Fil Buy Loc FlY = Yes 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-BUY-RQL-FL Alpha 1 AP125 AP126
Element: Fil Buy Rql FlY = Yes 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-VEN-OPTION Alpha 1 AP125 AP126
Element: Fil Ven OptionY = Items with no vendor 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-DEL-DAYS Numeric 3 AP125 AP126
Element: Fil Del Days 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-FRM-PRI Numeric 2 AP125 AP126
Element: Fil Frm Pri 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-TO-PRI Numeric 2 AP125 AP126
Element: Fil To Pri 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-NO-COST Alpha 1 AP125 AP126
Element: Fil No Cost Y = Items with no cost 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-PO-CODE Alpha 4 AP125 AP126
Element: Fil Po Code 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-MANUF-CODE Alpha 4 AP125 AP126
Element: Fil Manuf Code 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-MANUF-DIV Alpha 4 AP125 AP126
Element: Fil Manuf Div 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-AGRMT Alpha 30 AP125 AP126
Element: Fil Agrmt 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-FIL-ITEM-TYPE Alpha 1 AP125 AP126
Element: Fil Item Type I = Inventory AP131 AP20.1
N = Non Stock AP20.2 AP20.3
X = Special AP20.4 AP20.5
S = Service AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-MAN-OVER-ALWD Alpha 1
Element: Man Over Alwd If set to "Y", this field indicates that
unit costs manually entered for a
Purchase will be "held" and not
overridden by the cost default routine.
Y = Yes
N = No
BUY-OVER-AGRMT Alpha 1 AP125 AP126
Element: Over Agrmt Enter a Y to indicate the user can AP131 AP20.1
manually enter a cost which will not be AP20.2 AP20.3
overridden by an existing price AP20.4 AP20.5
agreement. AP20.7 AP21.1
Y = Yes AP23.1 AP25.1
N = No AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-OVER-LC-LP Alpha 1 AP125 AP126
Element: Over Lc Lp Enter a Y to indicate the user can AP131 AP20.1
manually enter a cost which will not be AP20.2 AP20.3
overridden by a last cost or last PO AP20.4 AP20.5
created cost default. AP20.7 AP21.1
Y = Yes AP23.1 AP25.1
N = No AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-EMAIL-ADDRESS Alpha 60 (Lower Case) AP125 AP126
Element: Email Address e-mail address. 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
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-BUY-OBJ-ID Numeric 12 AP125 AP126
Element: Obj Id This is the object identifier. It is AP131 AP20.1
used to relate commitments or posted AP20.2 AP20.3
transactions back to the originating AP20.4 AP20.5
subsystems. Each subsystem record that AP20.7 AP21.1
is updated as a commitment or posted AP23.1 AP25.1
transaction is assigned an object AP25.2 AP26.1
identifier. The object identifier is AP27.1 AP30.4
maintained in the subsystem files and in AP510 API1.1
the Activity Commitments Detail and BL120 BL122
Activity Transaction files. The object BL130 BL20.1
identifier is a unique key used to drill BL20.3 BL21.2
back from Activity Management to the BL21.5 BL29.1
subsystems. BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-REQ-COMM-CODE Numeric 1 AP125 AP126
Element: Req Comm Code 0 = Commodity Code Not Required AP131 AP20.1
1 = Commodity Code Required AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUY-P-CARD-FLAG Numeric 1
Element: Flag Num
BUY-PCARD-NBR Alpha 16
Element: Pcard Nbr
BUY-OVER-PCARD Numeric 1
Element: Over Pcard
BUY-OVER-SS Alpha 1 AP125 AP126
Element: Over Ss " " = No AP131 AP20.1
N = No AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC12.1 IC330
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA53.1 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
...
BUYER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BUYSET1 PROCURE-GROUP AP06.1 AP125
BUYER-CODE AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP205 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
BUYSET2 PROCURE-GROUP KeyChange MA278 PO04.1
BUYER-GRP PO115 PO120
BUYER-CODE PO15.1 PO15.2
PO204 PO220
PO223 PO224
PO225 PO229
PO230 PO251
PO254 PO275
PO276 PO277
PO280 PO54.1
PO54.2 PO54.3
PO54.4 POAB.1
BUYSET3 PROCURE-GROUP KeyChange, Subset PO04.1 PO23.1
OPERATOR-ID Where OPERATOR-ID != Spaces POII.1 POIJ.1
BUYSET4 BUY-OBJ-ID KeyChange, Subset MX223 MX500
Where BUY-OBJ-ID != Zeroes PO04.7 PO04.8
PO220 PO258
PO285 PO58.1
PO58.2 POBL.1
BUYER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Buyclass BUYCLASS
BUY-PROCURE-GROUP -> BCL-PROCURE-GROUP
BUY-BUYER-CODE -> BCL-BUYER-CODE
BCL-PURCH-MAJCL
BCL-PURCH-MINCL
Buycmploc BUYCMPLOC
BUY-PROCURE-GROUP -> BYC-PROCURE-GROUP
BUY-BUYER-CODE -> BYC-BUYER-CODE
BYC-COMPANY
BYC-LOCATION
BYC-REQ-LOCATION
Buyvenpf BUYVENPF
BUY-PROCURE-GROUP -> BVP-PROCURE-GROUP
BUY-BUYER-CODE -> BVP-BUYER-CODE
BVP-VENDOR
BVP-PURCH-FR-LOC
|
