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 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 PO00.1

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

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

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

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

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

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

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

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

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


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
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 PO00.1
PDPSET2 PROCURE-GROUP
PCARD-PROGRAM


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 (PDCSET1)
  PDC-REQUEST-NBR


File created: Wed Jun 08 20:50:43 2016

Home
Contact Us



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