PDCARD

P-Card

REFERENCED BY
PD00.1 PD01.1 PD260 AP10.1 AP10.2 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 AP510 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD130 PD20.1 PD20.2
PD20.3 PD57.1 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830


UPDATED BY
PD10.1 PD10.2 PD05.1 PD210 PD230

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDC-PCARD-PROGRAM
Element: Pcard Program		Alpha 10
PD10.1 PD10.2
PDC-REQUEST-NBR
Element: Request Nbr		Numeric 16
PD10.1 PD10.2
PDC-PCARD-NBR
Element: Pcard Nbr		Alpha 16
PD10.2
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
PD10.1 PD10.2
PDC-EFFECT-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PD10.2
PDC-EXP-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PD10.2
PDC-CARD-USER-NAME
Element: Card User Name		Alpha 30
PD10.1 PD10.2
PDC-USER-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code.
PD10.1 PD10.2
PDC-USER-PHONE
Element: Phone		Alpha 15
Phone number.
PD10.1 PD10.2
PDC-USER-EXT
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
PD10.1 PD10.2
PDC-EMAIL-ADDRESS
Element: Email Address		Alpha 60 (Lower Case)
e-mail address.
PD10.1 PD10.2
PDC-PROXY-NAME
Element: Card User Name		Alpha 30
PD10.1 PD10.2
PDC-PROXY-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code.
PD10.1 PD10.2
PDC-PROXY-PHONE
Element: Phone		Alpha 15
Phone number.
PD10.1 PD10.2
PDC-PROXY-EXT
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
PD10.1 PD10.2
PDC-PROXY-EMAIL
Element: Email Address		Alpha 60 (Lower Case)
e-mail address.
PD10.1 PD10.2
PDC-CARD-TYPE
Element: Flag		Alpha 1

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

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

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

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

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


PDCARD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDCSET1 PCARD-PROGRAM
REQUEST-NBR
PD00.1 PD01.1
PD05.1 PD10.1
PD10.2 PD10.3
PD210 PD230
PD260
PDCSET2 PCARD-NBR
PCARD-PROGRAM
REQUEST-NBR
KeyChange
...
AP10.1 AP10.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
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
Defcardcomp PDCARDCOMP Required
PDC-PCARD-PROGRAM->PCA-PCARD-PROGRAM (PCASET4)
PDC-REQUEST-NBR->PCA-REQUEST-NBR
Pdcarduser PDCARDUSER Not Required
PDP-PROCURE-GROUP->PCU-PROCURE-GROUP
PDC-CARD-USER-ID->PCU-CARD-USER-ID
Pdcarduser 2 PDCARDUSER Not Required
PDP-PROCURE-GROUP->PCU-PROCURE-GROUP
PDC-PROXY-USER-ID->PCU-CARD-USER-ID
Pdprogram PDPROGRAM Required
PDC-PCARD-PROGRAM->PDP-PCARD-PROGRAM


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: Thu Jun 09 02:26:26 2016

Home
Contact Us



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