|
|
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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Description This field displays the description. PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PTN-UNITS Signed 15.2
Element: Unit
PTN-BILLABLE-AMT Signed 15.2 BN66.1 PR140
Element: Adj Amt PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PTN-STATUS Numeric 1 BN66.1 PR140
Element: 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
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 BN66.1 PR140
Element: 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
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PTN-CURR-ND Numeric 1
Account Currency
Code
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
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 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
|
