PBTRANS FILE
UPDATED BY
PR197 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTN-COMPANY Numeric 4 PR197 PR85.1
Company The company number represents an
established company and is entered on
all function codes.
PTN-PROCESS-LEVEL Alpha 5 PR197 PR85.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PTN-DATE Numeric 8 (yyyymmdd) PR197 PR85.1
Date This field displays the system date
when this was created.
PTN-FEE-CODE Alpha 4 PR197 PR85.1
Fee Code
PTN-SEQ-NUMBER Numeric 6 PR197 PR85.1
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
PTN-PROGRAM Alpha 5 PR197 PR85.1
Program This field designates the program this
record was created by
PTN-DESCRIPTION Alpha 30 (Lower Case) PR197 PR85.1
Description This field displays the description.
PTN-UNITS Signed 15.2
Units 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
Billable Amt
PTN-STATUS Numeric 1 PR197 PR85.1
Status This field displays the status of the
transaction.
PTN-DATE-STAMP Numeric 8 (yyyymmdd) PR197
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
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PTN-EMPLOYEE Numeric 9 PR197 PR85.1
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
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PTN-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals 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 PR85.1
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
DATE
FEE-CODE
SEQ-NUMBER
PTNSET2 COMPANY Subset PR197 PR85.1
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 PR197
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
PTNSET6 FEE-CODE
COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
DATE
SEQ-NUMBER
|
