PDCARD

REFERENCED BY
PD260 PD00.1 PD05.1 PD210


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 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC140 IC66.1 IC83.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 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 PD01.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD230 PD57.1 PD570 PO100 PO101 PO122
PO131 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO28.2 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 RQ10.1 RQ10.2
RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIF.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
ZW130

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 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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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
Pdcarduser PDCARDUSER Not Required
PDP-PROCURE-GROUP->PCU-PROCURE-GROUP (PCUSET1)
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 11:23:35 2016

Home
Contact Us



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