PDCARD FILE
REFERENCED BY
PD01.1 PD05.1 PD210 PD230 PD260 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 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 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 PD570
PO100 PO101 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 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 POI3.1 POID.1
POII.1 POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
UPDATED BY
PD10.1 PD10.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDC-PCARD-PROGRAM Alpha 10 PD10.1 PD10.2
Element: Pcard Program
PDC-REQUEST-NBR Numeric 16 PD10.1 PD10.2
Element: Request Nbr
PDC-PCARD-NBR Alpha 16 PD10.2
Element: Pcard Nbr
PDC-STATUS Numeric 1 PD10.1 PD10.2
Element: Status This field displays the status of the
transaction.
0 = New
1 = Unapproved
2 = Approved
3 = Activated
8 = Rejected
9 = Cancelled
PDC-EFFECT-DATE Numeric 8 (yyyymmdd) PD10.2
Element: Date This field displays the system date
when this was created.
PDC-EXP-DATE Numeric 8 (yyyymmdd) PD10.2
Element: Date This field displays the system date
when this was created.
PDC-CARD-USER-NAME Alpha 30 PD10.1 PD10.2
Element: Card User Name
PDC-USER-PREFIX Alpha 6 PD10.1 PD10.2
Element: Phone Prefix The telephone number country code.
PDC-USER-PHONE Alpha 15 PD10.1 PD10.2
Element: Phone Phone number.
PDC-USER-EXT Alpha 5 PD10.1 PD10.2
Element: Phone Ext This field contains the telephone
extension number.
PDC-EMAIL-ADDRESS Alpha 60 (Lower Case) PD10.1 PD10.2
Element: Email Address e-mail address.
PDC-PROXY-NAME Alpha 30 PD10.1 PD10.2
Element: Card User Name
PDC-PROXY-PREFIX Alpha 6 PD10.1 PD10.2
Element: Phone Prefix The telephone number country code.
PDC-PROXY-PHONE Alpha 15 PD10.1 PD10.2
Element: Phone Phone number.
PDC-PROXY-EXT Alpha 5 PD10.1 PD10.2
Element: Phone Ext This field contains the telephone
extension number.
PDC-PROXY-EMAIL Alpha 60 (Lower Case) PD10.1 PD10.2
Element: Email Address e-mail address.
PDC-CARD-TYPE Alpha 1 PD10.2
Element: Flag S = Single
G = Group
PDC-BUYER-LIST Alpha 12 PD10.2
Element: Attribute
PDC-COM-CODE-FL Alpha 1
Element: Flag Y = Yes
N = No
PDC-TAX-FLAG Alpha 1 PD10.2
Element: Flag " " = None
T = Taxable
E = Exempt
PDC-TRAN-LIMIT Signed 18.2 PD10.2
Element: Intl Amt
PDC-MERCHANT-GRP Alpha 4 PD10.2
Element: Merch Grp
PDC-MERCHANT-FL Alpha 1 PD10.2
Element: Flag E = Exclude
I = Include
PDC-ITEM-LIST Alpha 12 PD10.2
Element: Attribute
PDC-ITEM-FL Alpha 1 PD10.2
Element: Flag E = Exclude
I = Include
PDC-USR-FLD-01 Alpha 20 PD10.1 PD10.2
Element: Usr Fld 01
PDC-USR-FLD-02 Alpha 20 PD10.1 PD10.2
Element: Usr Fld 02
PDC-USR-FLD-03 Alpha 20 PD10.1 PD10.2
Element: Usr Fld 03
PDC-USR-FLD-04 Alpha 20 PD10.1 PD10.2
Element: Usr Fld 04
PDC-USR-FLD-05 Alpha 20 PD10.1 PD10.2
Element: Usr Fld 05
PDC-USER-ID Alpha 10 (Lower Case) PD10.1 PD10.2
Element: User Id
PDC-EMPLOYEE Numeric 9 PD10.1 PD10.2
Element: Employee
PDC-NOTE Alpha 70 PD10.1 PD10.2
Element: Text
PDCARD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDCSET1 PCARD-PROGRAM PD01.1 PD05.1
REQUEST-NBR PD10.1 PD10.2
PD10.3 PD210
PD230 PD260
PDCSET2 PCARD-NBR KeyChange AP10.1 AP125
PCARD-PROGRAM AP126 AP131
REQUEST-NBR 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
PDCSET3 USER-ID KeyChange
PCARD-PROGRAM
PCARD-NBR
REQUEST-NBR
PDCSET4 EMPLOYEE KeyChange
PCARD-PROGRAM
PCARD-NBR
REQUEST-NBR
PDCARD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pdcardcomp PDCARDCOMP
PDC-PCARD-PROGRAM -> PCA-PCARD-PROGRAM (PCASET1)
PDC-REQUEST-NBR -> PCA-REQUEST-NBR
PCA-COMPANY
|
