PBTRANS FILE
UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR80.1
PR85.1 PR89.1 PR36.1 PR45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTN-COMPANY Numeric 4 BN66.1 PR140
Company The company number represents an PR189 PR195
established company and is entered on PR197 PR80.1
all function codes. PR85.1 PR89.1
PTN-PROCESS-LEVEL Alpha 5 BN66.1 PR140
Process Level This field contains the process level, PR189 PR195
which is the reporting hierarchy below PR197 PR80.1
company. PR85.1 PR89.1
PTN-DATE Numeric 8 (yyyymmdd) BN66.1 PR140
Date This field displays the system date PR189 PR195
when this was created. PR197 PR80.1
PR85.1 PR89.1
PTN-FEE-CODE Alpha 4 BN66.1 PR140
Fee Code PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PTN-SEQ-NUMBER Numeric 6 BN66.1 PR140
Record Sequence A unique number assigned to each PR189 PR195
Number transaction to be transferred into the PR197 PR80.1
Lawson system. PR85.1 PR89.1
PTN-PROGRAM Alpha 5 BN66.1 PR140
Program This field designates the program this PR189 PR195
record was created by PR197 PR80.1
PR85.1 PR89.1
PTN-DESCRIPTION Alpha 30 (Lower Case) BN66.1 PR140
Description This field displays the description. PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
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 BN66.1 PR140
Billable Amt PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PTN-STATUS Numeric 1 BN66.1 PR140
Status This field displays the status of the PR189 PR195
transaction. PR197 PR80.1
PR85.1 PR89.1
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 BN66.1 PR140
Employee Contains the employee number. Each PR189 PR195
person employed by the company is PR197 PR80.1
assigned a unique number. The system PR85.1 PR89.1
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 BN66.1 PR140
Internal Check ID Contains the payment identification PR189 PR195
Number number (unique payment identifier used PR197 PR80.1
in tracking payment information). PR85.1 PR89.1
PBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTNSET1 COMPANY BN66.1 PR140
PROCESS-LEVEL PR189 PR195
EMPLOYEE PR197 PR36.1
CHECK-ID PR45.1 PR80.1
DATE PR85.1 PR89.1
FEE-CODE
SEQ-NUMBER
PTNSET2 COMPANY Subset BN66.1 PR140
PROCESS-LEVEL Where (PROGRAM = "PB140" ) PR189 PR195
EMPLOYEE And (STATUS = 1 ) PR197 PR80.1
CHECK-ID PR85.1 PR89.1
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 BN66.1 PR140
PROCESS-LEVEL Where STATUS = 1 PR189 PR195
EMPLOYEE PR197 PR80.1
CHECK-ID PR85.1 PR89.1
DATE
FEE-CODE
SEQ-NUMBER
PTNSET6 FEE-CODE
COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
DATE
SEQ-NUMBER
|