|
|
PBTRANS FILE
UPDATED BY
PR197 PR85.1 PR36.1 PR45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTN-COMPANY Numeric 4 PR197 PR85.1
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.
PTN-PROCESS-LEVEL Alpha 5 PR197 PR85.1
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
PTN-DATE Numeric 8 (yyyymmdd) PR197 PR85.1
Element: Date This field displays the system date
when this was created.
PTN-FEE-CODE Alpha 4 PR197 PR85.1
Element: Fee Code
PTN-SEQ-NUMBER Numeric 6 PR197 PR85.1
Record Sequence A unique number assigned to each
Number transaction to be interfaced into the
Lawson system.
PTN-PROGRAM Alpha 5 PR197 PR85.1
Element: Program This field designates the program this
record was created by
PTN-DESCRIPTION Alpha 30 (Lower Case) PR197 PR85.1
Element: Description This field displays the description.
PTN-UNITS Signed 15.2
Element: Unit The element that explains the activity.
For example, a unit would be the number
of computers purchased.
PTN-BILLABLE-AMT Signed 15.2 PR197 PR85.1
Element: Billable Amt
PTN-STATUS Numeric 1 PR197 PR85.1
Element: Status This field displays the status of the
transaction.
PTN-DATE-STAMP Numeric 8 (yyyymmdd) PR197
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PTN-TIME-STAMP Numeric 6 (hhmmss) PR197
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PTN-EMPLOYEE Numeric 9 PR197 PR85.1
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.
PTN-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PTN-CURR-ND Numeric 1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PTN-CHECK-ID Numeric 12 PR197 PR85.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
PBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTNSET1 COMPANY PR197 PR36.1
PROCESS-LEVEL PR45.1 PR85.1
EMPLOYEE
CHECK-ID
DATE
FEE-CODE
SEQ-NUMBER
PTNSET2 COMPANY Subset
PROCESS-LEVEL Where (PROGRAM = "PB140" )
EMPLOYEE And (STATUS = 1 )
CHECK-ID
DATE
FEE-CODE
SEQ-NUMBER
PTNSET3 COMPANY Subset
PROCESS-LEVEL Where (PROGRAM = "PB40 " )
EMPLOYEE And (EMPLOYEE = Zeroes )
CHECK-ID And ((STATUS = Zeroes )
DATE Or (STATUS = 1 ))
FEE-CODE
SEQ-NUMBER
PTNSET4 COMPANY Subset
DATE-STAMP Where STATUS = 9
TIME-STAMP
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
DATE
FEE-CODE
SEQ-NUMBER
PTNSET5 COMPANY Subset PR197 PR85.1
PROCESS-LEVEL Where STATUS = 1
EMPLOYEE
CHECK-ID
DATE
FEE-CODE
SEQ-NUMBER
PBTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
PTN-COMPANY -> EMP-COMPANY
PTN-EMPLOYEE -> EMP-EMPLOYEE
|
