PBDISTRIB FILE
UPDATED BY
PR197 PR198
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDB-COMPANY Numeric 4 PR197
Company The company number represents an
established company and is entered on
all function codes.
PDB-EMPLOYEE Numeric 9 PR197
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
Status This field displays the status of the
transaction.
PDB-PROCESS-LEVEL Alpha 5 PR197
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PDB-DEPARTMENT Alpha 5 PR197
Department Contains the department.
PDB-RECORD-TYPE Alpha 1 PR197
Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
PDB-CHECK-TYPE Alpha 1 PR197
Payment Type Contains the payment type.
PDB-DST-ACCT-UNIT Alpha 15 PR197
Distribution Contains the General Ledger accounting
Accounting Unit unit to which the amount is posted.
PDB-DST-ACCOUNT Numeric 6 PR197
Distribution Contains the General Ledger account to
Account Number which the amount is posted.
PDB-DST-SUB-ACCT Numeric 4 PR197
Distribution Contains the General Ledger subaccount
Subaccount Number to which the amount is posted.
PDB-DIST-COMPANY Numeric 4 PR197
Distribution Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
PDB-PCD-SEQ-NBR Numeric 4 PR197
Pcd Seq Nbr
PDB-DED-CODE Alpha 4 PR197
Deduction Code
PDB-HOURS Signed 7.2 PR197
Hours Contains the hours.
PDB-DIST-AMT Signed 13.2 PR197
Distribution Amount
PDB-GL-DATE Numeric 8 (yyyymmdd) PR197
General Ledger Date This field contains the general ledger
posting date.
PDB-JOB-CODE Alpha 9 PR197
Job Code Contains a user-defined code that
represents a type of job.
PDB-RUN-DATE Numeric 8 (yyyymmdd) PR197 PR198
Program Run Date The date a transaction is posted to
general ledger.
PDB-RUN-TIME Numeric 6 (hhmmss) PR197 PR198
Program Run Time Contains the time a transaction is
posted to the general ledger.
PDB-ACTIVITY Alpha 15 PR197
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 PR198
Subsystem GL This is a subsystem GL interface
Interface ID identification number. It is used for
Drill Around purposes.
PDB-ATN-OBJ-ID Numeric 12 PR197 PR198
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
PDB-POSITION Alpha 12 PR197
Position Contains the user-defined code that
represents a position in the company.
PDB-ACCT-CATEGORY Alpha 5 PR197
Account Category Account 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
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PDB-CURR-ND Numeric 1 PR197
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PDB-ERROR-TYPE Numeric 1 PR197
Error Type
PDB-CO-CURR-CD Alpha 5 PR197
Co Curr Cd
PDB-DST-CO-CURR-CD Alpha 5 PR197
Dst Co Curr Cd
PDB-CO-EXCH-RATE Signed 12.6 PR197
Co Exch Rate
PDB-DIST-EXCH-RATE Signed 12.6 PR197
Dist Exch Rate
PDB-MSG-NBR Numeric 3 Occurs 10 Times PR197
Msg Nbr
PDB-HM-PROC-LEVEL Alpha 5 PR197
Hm Proc Level
PDB-ATTEND-CODE Alpha 2 PR197
Attendance Code A 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
Ac Updated Indicates the completion of AC530 for
Activity Management commitments.
PDB-INVOICE Alpha 22
Invoice Number Used to identify the invoice.
PDB-GARN-OBJ-ID Numeric 12 PR197
Garn Obj Id
PDB-SEGMENT-SEQ Numeric 12 PR197
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
|
