|
BUYCMPLOC FILE
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 AP510 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 DR100 IC12.1 IC141
IC142 IC28.1 IC330 IC83.1 MA180 MA278
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.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 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE81.1 OE810 OE830 OE90.1 OE90.2 PO10.1
PO100 PO101 PO115 PO120 PO122 PO131
PO15.1 PO15.2 PO150 PO20.1 PO204 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO224
PO225 PO229 PO23.1 PO23.5 PO230 PO25.1
PO25.6 PO25.7 PO251 PO275 PO276 PO277
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POI3.1 POIE.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 The user defined buyer identifier.
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 Code This field contains a valid stocking
location within the company inventory.
BYC-REQ-LOCATION Alpha 5 PO04.3
Element: To 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 AP25.1
COMPANY AP25.2 AP26.1
LOCATION AP27.1 AP30.4
REQ-LOCATION AP510 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC12.1 IC141
IC142 IC28.1
IC330 IC83.1
MA180 MA278
...
BYCSET2 PROCURE-GROUP PO01.1
COMPANY
BUYER-CODE
LOCATION
REQ-LOCATION
BYCSET3 PROCURE-GROUP Subset AP125 AP126
BUYER-CODE Where LOCATION = Spaces AP131 AP25.1
COMPANY And REQ-LOCATION = Spaces AP25.2 AP26.1
AP27.1 AP30.4
AP510 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC12.1 IC141
IC142 IC28.1
IC330 IC83.1
MA180 MA278
...
BYCSET4 PROCURE-GROUP Subset AP125 AP126
BUYER-CODE Where LOCATION != Spaces AP131 AP25.1
COMPANY And REQ-LOCATION = Spaces AP25.2 AP26.1
LOCATION AP27.1 AP30.4
AP510 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC12.1 IC141
IC142 IC28.1
IC330 IC83.1
MA180 MA278
...
BYCSET5 PROCURE-GROUP Subset AP125 AP126
BUYER-CODE Where REQ-LOCATION != Spaces AP131 AP25.1
COMPANY And LOCATION = Spaces AP25.2 AP26.1
REQ-LOCATION AP27.1 AP30.4
AP510 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC12.1 IC141
IC142 IC28.1
IC330 IC83.1
MA180 MA278
...
|