PDCARDUSER

REFERENCED BY
PD20.1 PD20.2 PD20.3 PD230 PD235 PD57.1
PD570 PD210


UPDATED BY
PD00.1 PD01.1 PD10.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCU-PROCURE-GROUP
Element: Procure Group
Alpha 4
This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.
PD00.1 PD01.1
PD10.2
PCU-CARD-USER-ID
Element: Card User Id
Alpha 10 (Lower Case)
This field contains the identifier for the Procurement Card user, administrator or proxy.
PD00.1 PD01.1
PD10.2
PCU-NAME
Element: Name
Alpha 30 (Lower Case)
This field contains the name of the Procurement Card user, administrator or proxy.
PD00.1 PD01.1
PD10.2
PCU-INT-PREFIX
Element: Phone Prefix
Alpha 6
The telephone number country code.
PD00.1 PD01.1
PD10.2
PCU-PHONE-NMBR
Element: Phone
Alpha 15
Phone number.
PD00.1 PD01.1
PD10.2
PCU-PHONE-EXT
Element: Phone Ext
Alpha 5
Telephone extension number.
PD00.1 PD01.1
PD10.2
PCU-FAX-PREFIX
Element: Phone Prefix
Alpha 6
The fax number country code.
PD00.1
PCU-FAX-NMBR
Element: Phone
Alpha 15
Fax number.
PD00.1
PCU-FAX-EXT
Element: Phone Ext
Alpha 5
Fax number extension.
PD00.1
PCU-NOTE
Element: Long Desc
Alpha 60 (Lower Case)
Additional notes.
PD00.1 PD10.2
PCU-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
Email address.
PD00.1 PD01.1
PD10.2
PCU-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the Procurement Card user. If Inactive, cannot be assigned as an administrator or proxy and cannot request a new card.
A = Active
I = Inactive
PD00.1 PD01.1
PD10.2
PCU-ADMINISTRATOR
Element: All Flag
Alpha 1
This field indicates whether the Procurement Card user is also a PCards Program administrator.
Y = Yes
N = No
PD00.1 PD01.1
PD10.2
PCU-PROXY
Element: All Flag
Alpha 1
This field indicates whether a Procurement Card user is also a proxy.
Y = Yes
N = No
PD00.1 PD01.1
PD10.2
PCU-COMPANY
Element: Company
Numeric 4
Company number.
PD00.1
PCU-EMPLOYEE
Element: Employee
Numeric 9
Contains the number assigned to each employee.
PD00.1 PD10.2


PDCARDUSER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCUSET1 PROCURE-GROUP
CARD-USER-ID
PD00.1 PD01.1
PD10.1 PD10.2
PD20.1 PD20.2
PD20.3 PD210
PD230 PD235
PD57.1 PD570


PDCARDUSER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdcard PDCARD
PCU-CARD-USER-ID->PDC-CARD-USER-ID
  PDC-PCARD-PROGRAM
  PDC-PCARD-NBR
  PDC-REQUEST-NBR
Pdcard Proxy PDCARD
PCU-CARD-USER-ID->PDC-PROXY-USER-ID
  PDC-PCARD-PROGRAM
  PDC-PCARD-NBR
  PDC-REQUEST-NBR


File created: Thu Jun 09 11:23:35 2016

Home
Contact Us



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