|
|
PBDISTRIB FILE
UPDATED BY
PR197 PR198
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDB-COMPANY Numeric 4 PR197
Element: Company The company number represents an
established company and is entered on
all function codes.
PDB-EMPLOYEE Numeric 9 PR197
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PDB-CHECK-ID Numeric 12 PR197
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
PDB-OBJ-ID Numeric 12 PR197
Object This is the object identifier. It is
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
PDB-STATUS Numeric 1 PR198
Element: Status This field displays the status of the
transaction.
PDB-PROCESS-LEVEL Alpha 5 PR197
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PDB-DEPARTMENT Alpha 5 PR197
Element: Department Contains the department.
PDB-RECORD-TYPE Alpha 1 PR197
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
PDB-CHECK-TYPE Alpha 1 PR197
Element: Payment Type Contains the payment type.
PDB-DST-ACCT-UNIT Alpha 15 PR197
Element: Accounting Unit
PDB-DST-ACCOUNT Numeric 6 PR197
Element: Account
PDB-DST-SUB-ACCT Numeric 4 PR197
Element: Subaccount
PDB-DIST-COMPANY Numeric 4 PR197
Element: Company
PDB-PCD-SEQ-NBR Numeric 4 PR197
Element: Pcd Seq Nbr
PDB-DED-CODE Alpha 4 PR197
Element: Deduction Code
PDB-HOURS Signed 7.2 PR197
Element: Hours Contains the hours.
PDB-DIST-AMT Signed 13.2 PR197
Element: Distribution Amount
PDB-GL-DATE Numeric 8 (yyyymmdd) PR197
Element: Date
PDB-JOB-CODE Alpha 9 PR197
Element: Job Code Contains a user-defined code that
represents a type of job.
PDB-RUN-DATE Numeric 8 (yyyymmdd) PR197 PR198
Element: Date
PDB-RUN-TIME Numeric 6 (hhmmss) PR197 PR198
Element: Sys Time
PDB-ACTIVITY Alpha 15 PR197
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PDB-GLT-OBJ-ID Numeric 12 PR197 PR198
Object
Identification
PDB-ATN-OBJ-ID Numeric 12 PR197 PR198
Object
Identification
PDB-POSITION Alpha 12 PR197
Element: Position Contains the user-defined code that
represents a position in the company.
PDB-ACCT-CATEGORY Alpha 5 PR197
Element: Account CategoAccount categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
PDB-CURRENCY-CODE Alpha 5 PR197
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PDB-CURR-ND Numeric 1 PR197
Account Currency
Code
PDB-ERROR-TYPE Numeric 1 PR197
Element: Error Type
PDB-CO-CURR-CD Alpha 5 PR197
Element: Co Curr Cd
PDB-DST-CO-CURR-CD Alpha 5 PR197
Element: Dst Co Curr Cd
PDB-CO-EXCH-RATE Signed 12.6 PR197
Element: Co Exch Rate
PDB-DIST-EXCH-RATE Signed 12.6 PR197
Element: Dist Exch Rate
PDB-MSG-NBR Numeric 3 Occurs 10 Times PR197
Element: Msg Nbr
PDB-HM-PROC-LEVEL Alpha 5 PR197
Element: Hm Proc Level
PDB-ATTEND-CODE Alpha 2 PR197
Element: Attendance CodA user-defined alphanumeric code that
represents a reason for an employee's
absence or hours worked. Examples of
attendance codes are, sick, vacation,
overtime, on the job injury, snow day,
tardy, left early, and so on. Validated
in the Attendance Code file.
PDB-AC-UPDATED Alpha 1 PR197
Element: Ac191 Updated
PDB-INVOICE Alpha 22
Element: Invoice NumberUsed to identify the invoice.
PDB-GARN-OBJ-ID Numeric 12 PR197
Element: Garn Obj Id
PDB-SEGMENT-SEQ Numeric 12 PR197
Element: Segment Seq
PBDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDBSET1 COMPANY PR198
EMPLOYEE
CHECK-ID
OBJ-ID
PDBSET2 COMPANY
EMPLOYEE
GL-DATE
CHECK-ID
OBJ-ID
PDBSET3 DIST-COMPANY
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
GLT-OBJ-ID
OBJ-ID
PDBSET4 COMPANY PR198
STATUS
ERROR-TYPE
HM-PROC-LEVEL
DIST-COMPANY
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
GL-DATE
EMPLOYEE
CHECK-ID
OBJ-ID
PDBSET5 COMPANY Subset
ACTIVITY Where ACTIVITY != Spaces
ATN-OBJ-ID
EMPLOYEE
OBJ-ID
PDBSET6 COMPANY Subset PR198
PROCESS-LEVEL Where STATUS = 9
EMPLOYEE
GL-DATE
CHECK-ID
OBJ-ID
PBDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
PDB-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
PDB-ACTIVITY -> ACV-ACTIVITY
Gltrans GLTRANS Required
PDB-GLT-OBJ-ID -> GLT-OBJ-ID
Paymastr PAYMASTR Required
PDB-COMPANY -> PYM-COMPANY
PDB-EMPLOYEE -> PYM-EMPLOYEE
PDB-CHECK-ID -> PYM-CHECK-ID
PBDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pbhstdtl PBHSTDTL
PDB-COMPANY -> PBH-COMPANY
PDB-EMPLOYEE -> PBH-EMPLOYEE
PDB-CHECK-ID -> PBH-CHECK-ID
PDB-PROCESS-LEVEL -> PBH-PROCESS-LEVEL
PBH-INVOICE
PBH-LINE-NBR
Sltrans SLTRANS
PDB-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|
