|
|
PBDISTRIB FILE
Pay to Bill Distributions
UPDATED BY
PR197 PR198
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDB-COMPANY Numeric 4 PR197
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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 Lev HrThis 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 UniContains the General Ledger accounting
unit to which the amount is posted.
PDB-DST-ACCOUNT Numeric 6 PR197
Element: Account Contains the General Ledger account to
which the amount is posted.
PDB-DST-SUB-ACCT Numeric 4 PR197
Element: Subaccount Contains the General Ledger subaccount
to which the amount is posted.
PDB-DIST-COMPANY Numeric 4 PR197
Element: 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
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: General LedgerThis field contains the general ledger
posting 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: Program Run DaThe date a transaction is posted to
general ledger.
PDB-RUN-TIME Numeric 6 (hhmmss) PR197 PR198
Element: Sys Time Contains the time a transaction is
posted to the general ledger.
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 This is a subsystem GL interface
Identification identification number. It is used for
Drill Around purposes.
PDB-ATN-OBJ-ID Numeric 12 PR197 PR198
Object The system-defined object id
Identification representing the Activity Management
commitment.
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.
Valid account category types are:
cost
revenue
accrual
pass thru
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 Represents the number of decimals
Code defined for the currency of the object.
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 14.7 PR197
Element: Co Exch Rate
PDB-DIST-EXCH-RATE Signed 14.7 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: Process Lev HrContains the employee's home process
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 Indicates the completion of AC530 for
Activity Management commitments.
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
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
Employee EMPLOYEE Required
PDB-COMPANY -> EMP-COMPANY
PDB-EMPLOYEE -> EMP-EMPLOYEE
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
|
