|
BUYCMPLOC FILE
REFERENCED 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 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
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
PO23.5 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
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 PO01.1
UPDATED BY
PO04.1 PO04.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BYC-PROCURE-GROUP Alpha 4 PO04.3
Element: Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
BYC-BUYER-CODE Alpha 3 PO04.3
Element: Buyer
BYC-COMPANY Numeric 4 PO04.3
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
BYC-LOCATION Alpha 5 PO04.3
Element: Location This field contains a valid stocking
location within the company inventory.
BYC-REQ-LOCATION Alpha 5 PO04.3
Element: Req Location The location requisitioning items.
This location can be an inventory or
noninventory location.
BUYCMPLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BYCSET1 PROCURE-GROUP AP125 AP126
BUYER-CODE AP131 AP20.1
COMPANY AP20.2 AP20.3
LOCATION AP20.4 AP20.5
REQ-LOCATION 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
...
BYCSET2 PROCURE-GROUP PO01.1
COMPANY
BUYER-CODE
LOCATION
REQ-LOCATION
BYCSET3 PROCURE-GROUP Subset AP125 AP126
BUYER-CODE Where LOCATION = Spaces AP131 AP20.1
COMPANY And REQ-LOCATION = Spaces 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
...
BYCSET4 PROCURE-GROUP Subset AP125 AP126
BUYER-CODE Where LOCATION != Spaces AP131 AP20.1
COMPANY And REQ-LOCATION = Spaces AP20.2 AP20.3
LOCATION 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
...
BYCSET5 PROCURE-GROUP Subset AP125 AP126
BUYER-CODE Where REQ-LOCATION != Spaces AP131 AP20.1
COMPANY And LOCATION = Spaces AP20.2 AP20.3
REQ-LOCATION 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
...
|