PDPROGRAM

REFERENCED BY
AP145 AP146 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP245 API1.1
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 PD06.1 PD130 PD20.1 PD20.2
PD20.3 PD21.1 PD22.1 PD230 PD235 PD260
PD57.1 PD57.2 PD57.3 PD570 PD00.1 PD04.1
PD05.1 PD08.1 PD201 PD204 PD210 PO00.1


UPDATED BY
PD01.1 PD01.2 PD10.1 PD10.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDP-PCARD-PROGRAM
Element: Pcard Program		Alpha 10
PD01.1
PDP-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
PD01.1
PDP-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.
PD01.1
PDP-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = Active
9 = Cancelled
PD01.1
PDP-EFFECT-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PD01.1
PDP-ADMIN
Element: Name 2		Alpha 30
PD01.1
PDP-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code.
PD01.1
PDP-PHONE
Element: Phone		Alpha 15
Phone number.
PD01.1
PDP-EXTENSION
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
PD01.1
PDP-EMAIL
Element: Email Address		Alpha 60 (Lower Case)
e-mail address.
PD01.1
PDP-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
PD01.1
PDP-MASK-FL
Element: Flag		Alpha 1

Y = Yes
N = No
PD01.1
PDP-INV-CREATE-FL
Element: Flag		Alpha 1

Y = Yes
N = No
PDP-DISP-REASON-FL
Element: Flag		Alpha 1

Y = Yes
N = No
PD01.1
PDP-DISP-EXP-FL
Element: Flag		Alpha 1

Y = Yes
N = No
PDP-LAST-REQUEST
Element: Request Nbr		Numeric 16
PD10.1 PD10.2
PDP-CHARGE-APPR-FL
Element: Flag		Alpha 1

N = No
P = PO Charges Only
A = Adhoc Charges Only
B = Both
PD01.1
PDP-AUTO-ADD
Element: Flag		Alpha 1

Y = Yes
N = No
PD01.1
PDP-CHARGE-CLS-FL
Element: Flag		Alpha 1

N = No
P = PO Charges Only
A = Adhoc Charges Only
B = Both
PD01.1
PDP-TRACK-CARDS-FL
Element: Flag		Alpha 1
PDP-AUTO-ADD-USER
Element: Flag		Alpha 1

Y = Yes
N = No
PD01.1
PDP-ADMIN-USER-ID
Element: Card User Id		Alpha 10 (Lower Case)
PD01.1


PDPROGRAM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDPSET1 PCARD-PROGRAM
...
AP145 AP146
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP245 API1.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
PD00.1 PD01.1
PD01.2 PD04.1
PD05.1 PD06.1
PD08.1 PD10.1
PD10.2 PD10.3
PDPSET2 PROCURE-GROUP
PCARD-PROGRAM


PDPROGRAM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdcarduser PDCARDUSER Not Required
PDP-PROCURE-GROUP->PCU-PROCURE-GROUP (PCUSET1)
PDP-ADMIN-USER-ID->PCU-CARD-USER-ID


PDPROGRAM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdcard PDCARD Delete Cascades
PDP-PCARD-PROGRAM->PDC-PCARD-PROGRAM
  PDC-REQUEST-NBR
Pdprogcomp PDPROGCOMP Delete Cascades
PDP-PCARD-PROGRAM->PGC-PCARD-PROGRAM
  PGC-COMPANY

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

Home
Contact Us



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