Lawson Insight Technical Documentation |
|
PDPROGRAM
PDPROGRAM FILE
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.2 PD04.1
PD05.1 PD06.1 PD08.1 PD130 PD20.1 PD20.2
PD20.3 PD201 PD204 PD21.1 PD210 PD22.1
PD230 PD235 PD260 PD570 PO00.1
UPDATED BY
PD01.1 PD10.1 PD10.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDP-PCARD-PROGRAM Alpha 10 PD01.1
Element: Pcard Program
PDP-DESCRIPTION Alpha 30 (Lower Case) PD01.1
Element: Description This field displays the description.
PDP-PROCURE-GROUP Alpha 4 PD01.1
Element: Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
PDP-STATUS Numeric 1 PD01.1
Element: Status This field displays the status of the
transaction.
0 = Active
9 = Cancelled
PDP-EFFECT-DATE Numeric 8 (yyyymmdd) PD01.1
Element: Date This field displays the system date
when this was created.
PDP-ADMIN Alpha 30 PD01.1
Element: Name 2
PDP-PREFIX Alpha 6 PD01.1
Element: Phone Prefix The telephone number country code.
PDP-PHONE Alpha 15 PD01.1
Element: Phone Phone number.
PDP-EXTENSION Alpha 5 PD01.1
Element: Phone Ext This field contains the telephone
extension number.
PDP-EMAIL Alpha 60 (Lower Case) PD01.1
Element: Email Address e-mail address.
PDP-VENDOR Alpha 9 (Right Justified) PD01.1
Element: Vendor The vendor's identification code.
PDP-MASK-FL Alpha 1 PD01.1
Element: Flag Y = Yes
N = No
PDP-INV-CREATE-FL Alpha 1
Element: Flag Y = Yes
N = No
PDP-DISP-REASON-FL Alpha 1 PD01.1
Element: Flag Y = Yes
N = No
PDP-DISP-EXP-FL Alpha 1
Element: Flag Y = Yes
N = No
PDP-LAST-REQUEST Numeric 16 PD10.1 PD10.2
Element: Request Nbr
PDP-CHARGE-APPR-FL Alpha 1 PD01.1
Element: Flag N = No
P = PO Charges Only
A = Adhoc Charges Only
B = Both
PDP-AUTO-ADD Alpha 1 PD01.1
Element: Flag Y = Yes
N = No
PDP-CHARGE-CLS-FL Alpha 1 PD01.1
Element: Flag N = No
P = PO Charges Only
A = Adhoc Charges Only
B = Both
PDP-TRACK-CARDS-FL Alpha 1
Element: Flag
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.2 PD01.1
PD01.2 PD04.1
PD05.1 PD06.1
PD08.1 PD10.1
PD10.2 PD10.3
PD130 PD20.1
PD20.2 PD20.3
...
PDPSET2 PROCURE-GROUP
PCARD-PROGRAM
PDPROGRAM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pdcard PDCARD Delete Cascades
PDP-PCARD-PROGRAM -> PDC-PCARD-PROGRAM (PDCSET1)
PDC-REQUEST-NBR
Pdprogcomp PDPROGCOMP Delete Cascades
PDP-PCARD-PROGRAM -> PGC-PCARD-PROGRAM
PGC-COMPANY
|