PDCARD

UPDATED BY
AP10.1 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 API1.1
API2.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDC-PCARD-PROGRAM
Element: Pcard Program		Alpha 10
PDC-REQUEST-NBR
Element: Request Nbr		Numeric 16
PDC-PCARD-NBR
Element: Pcard Nbr		Alpha 16
PDC-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = New
1 = Unapproved
2 = Approved
3 = Activated
8 = Rejected
9 = Cancelled
PDC-EFFECT-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PDC-EXP-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PDC-CARD-USER-NAME
Element: Card User Name		Alpha 30
PDC-USER-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code.
PDC-USER-PHONE
Element: Phone		Alpha 15
Phone number.
PDC-USER-EXT
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
PDC-EMAIL-ADDRESS
Element: Email Address		Alpha 60 (Lower Case)
e-mail address.
PDC-PROXY-NAME
Element: Card User Name		Alpha 30
PDC-PROXY-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code.
PDC-PROXY-PHONE
Element: Phone		Alpha 15
Phone number.
PDC-PROXY-EXT
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
PDC-PROXY-EMAIL
Element: Email Address		Alpha 60 (Lower Case)
e-mail address.
PDC-CARD-TYPE
Element: Flag		Alpha 1

S = Single
G = Group
PDC-BUYER-LIST
Element: Attribute		Alpha 12
PDC-COM-CODE-FL
Element: Flag		Alpha 1

Y = Yes
N = No
PDC-TAX-FLAG
Element: Flag		Alpha 1

" " = None
T = Taxable
E = Exempt
PDC-TRAN-LIMIT
Element: Intl Amt		Signed 18.2
PDC-MERCHANT-GRP
Element: Merch Grp		Alpha 4
PDC-MERCHANT-FL
Element: Flag		Alpha 1

E = Exclude
I = Include
PDC-ITEM-LIST
Element: Attribute		Alpha 12
PDC-ITEM-FL
Element: Flag		Alpha 1

E = Exclude
I = Include
PDC-USR-FLD-01
Element: Usr Fld 01		Alpha 20
PDC-USR-FLD-02
Element: Usr Fld 02		Alpha 20
PDC-USR-FLD-03
Element: Usr Fld 03		Alpha 20
PDC-USR-FLD-04
Element: Usr Fld 04		Alpha 20
PDC-USR-FLD-05
Element: Usr Fld 05		Alpha 20
PDC-USER-ID
Element: Ldap User		Alpha 80
PDC-EMPLOYEE
Element: Employee		Numeric 9
PDC-NOTE
Element: Text		Alpha 70
PDC-CARD-USER-ID
Element: Card User Id		Alpha 10 (Lower Case)
PDC-PROXY-USER-ID
Element: Card User Id		Alpha 10 (Lower Case)


PDCARD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDCSET1 PCARD-PROGRAM
REQUEST-NBR
PDCSET2 PCARD-NBR
PCARD-PROGRAM
REQUEST-NBR
KeyChange
...
AP10.1 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PDCSET3 USER-ID
PCARD-PROGRAM
PCARD-NBR
REQUEST-NBR
KeyChange
PDCSET4 EMPLOYEE
PCARD-PROGRAM
PCARD-NBR
REQUEST-NBR
KeyChange
PDCSET5 CARD-USER-ID
PCARD-PROGRAM
PCARD-NBR
REQUEST-NBR
KeyChange
PDCSET6 PROXY-USER-ID
PCARD-PROGRAM
PCARD-NBR
REQUEST-NBR
KeyChange


PDCARD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdprogram PDPROGRAM Required
PDC-PCARD-PROGRAM->PDP-PCARD-PROGRAM (PDPSET1)


PDCARD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdcardcomp PDCARDCOMP
PDC-PCARD-PROGRAM->PCA-PCARD-PROGRAM
PDC-REQUEST-NBR->PCA-REQUEST-NBR
  PCA-COMPANY

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

Home
Contact Us



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