ITEMSRC

UPDATED BY
PO520 POII.1 POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITM-COMPANY
Element: Company		Numeric 4
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.
ITM-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
ITM-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
ITM-REPLENISH-PRI
Element: Replenish Pri		Numeric 6
Replenishment Priority. A priority of 1 is the top priority.
ITM-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
ITM-PURCH-FR-LOC
Element: Purch Fr Loc		Alpha 4
The vendor's purchase from location.
ITM-REPL-FROM-CO
Element: Company		Numeric 4
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.
ITM-REPL-FROM-LOC
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
ITM-REPL-FROM-BIN
Element: Bin		Alpha 7
This field contains a storage area for an item or any number of items.


ITEMSRC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITMSET1 COMPANY
LOCATION
ITEM
REPLENISH-PRI
PO520 POII.1
POIJ.1
ITMSET2 REPL-FROM-CO
REPL-FROM-LOC
COMPANY
LOCATION
ITEM
REPLENISH-PRI
ITMSET3 VENDOR
PURCH-FR-LOC
COMPANY
LOCATION
ITEM
REPLENISH-PRI
KeyChange
ITMSET4 COMPANY
LOCATION
VENDOR
ITEM
PURCH-FR-LOC
KeyChange, Subset
WhereVENDOR !=Spaces
ITMSET5 COMPANY
LOCATION
ITEM
VENDOR
PURCH-FR-LOC
KeyChange, Subset
WhereVENDOR !=Spaces


ITEMSRC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When ITM-VENDOR !=Spaces
ITM-COMPANY->CPY-COMPANY
Company ICCOMPANY Required
ITM-COMPANY->ICC-COMPANY
Gl Company GLSYSTEM Required
ITM-COMPANY->GLS-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
ITM-ITEM->ITE-ITEM
Location ICLOCATION Required
ITM-COMPANY->ICL-COMPANY
ITM-LOCATION->ICL-LOCATION
Procuregrp PROCUREGRP Required
ICC-ITEM-GROUP->PCG-ITEM-GROUP
Repl From Bin ICBIN Required
ITM-REPL-FROM-CO->ICB-COMPANY
ITM-REPL-FROM-LOC->ICB-LOCATION
ITM-REPL-FROM-BIN->ICB-BIN
Repl Itemloc ITEMLOC Not Required
ITM-REPL-FROM-CO->ITL-COMPANY
ITM-REPL-FROM-LOC->ITL-LOCATION
ITM-ITEM->ITL-ITEM
Vendloc APVENLOC Required
When ITM-VENDOR !=Spaces
CPY-VENDOR-GROUP->VLO-VENDOR-GROUP
ITM-VENDOR->VLO-VENDOR
ITM-PURCH-FR-LOC->VLO-LOCATION-CODE
Vendmast APVENMAST Required
When ITM-VENDOR !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
ITM-VENDOR->VEN-VENDOR
Vendorgroup APVENGROUP Required
When ITM-VENDOR !=Spaces
CPY-VENDOR-GROUP->VGP-VENDOR-GROUP


ITEMSRC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Poitemven POITEMVEN
PCG-PROCURE-GROUP->PIV-PROCURE-GROUP
ITM-ITEM->PIV-ITEM
ITM-VENDOR->PIV-VENDOR
  PIV-VEN-ITEM

File created: Wed Jun 08 20:49:40 2016

Home
Contact Us



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