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.