ABTRANS FILE
The Assignment Billing Transaction File stores bill and pay information
collected from time records. It is the source file for the billing/invoice
calculation process to pull together invoicing information that will be sent
to the Consolidated Invoicing system. This file will have a one-to-one
relationship with the TIMERECORD and the PRTIME file once the Payroll Cycle
is closed.
REFERENCED BY
PR160 PR180 PR80.2
UPDATED BY
AC542 PR195 PR197 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABN-OBJ-ID Numeric 12
Object Unique identifier for an ABTRANS
Identification record, used to relate to other files.
ABN-ASSIGNMENT Alpha 15
Assignment The job assignment number or code that
identifies the matching of a candidate
with a job request.
ABN-WRK-END-DATE Numeric 8 (yyyymmdd)
Wrk End Date Work period end date in yyyymmdd format.
ABN-TR-DATE Numeric 8 (yyyymmdd)
Time Record Date Date that the work was performed in
yyyymmdd format.
ABN-EMPLOYEE-TYPE Alpha 1
Employee Type Indicates if the employee is an HR
employee or a subcontract employee.
Valid values are:
S = Subcontract Employee
E = HR Employee
ABN-EMPLOYEE Numeric 9
Employee HR or Subcontract employee ID
ABN-TIME-SEQ Numeric 12
Sequence Number This field will match the value of the
TIME-SEQ field on the TIMERECORD file
for the related record. This keeps time
records unique per employee.
ABN-HR-COMPANY Numeric 4
HR Company The Human Resources (HR) company to
which the employee is assigned. Must be
a valid HR company defined in Company
(HR00.1).
ABN-PR-PROCESS-LVL Alpha 5
Pr Process Lvl The process level to which the employee
is assigned. Must be a valid process
level defined on Process Level (HR01.1)
for the company.
ABN-DEPARTMENT Alpha 5
Department The department to the employee is
assigned. Must be a valid department
defined on Department (HR02.1) for the
company and process level
ABN-PR-STATUS Numeric 1 AC542 PR195
Pr Status Indicates the status of the ABTRANS PR197 PR82.1
record with regards to Payroll. The PR85.1
values of 1, 2, and 9 should always be
in sync with the STATUS field in
TIMERECORD. To determine other status
values (Error, Processed or Manual, the
AB programs will read the value from the
TIMERECORD STATUS field value. The
PR-STATUS will be set to 9 by Payroll
Closing (PR197).
Payroll status 0 (Unreleased) Batch is
not used by the AB system.
The translations for status 1 and 2 are
different for AB, but they match
TIMERECORD in meaning for processing.
Valid Values are:
1 = Unapproved (Future in PR system)
2 = Approved (Current in PR
system)
9 = Closed
ABN-STATUS Numeric 1
Status indicates whether the amount has been
posted to the balance files within the
Assignment Billing application. Valid
values are:
0 = Unposted
9 = Posted
ABN-PAY-CODE Alpha 4
Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
ABN-PAY-HOURS Signed 7.2
Pay Hours The pay hours included in the pay
period, if the pay unit of measure is of
type H (hours).
ABN-PAY-UNITS Signed 7.2
Pay Units The pay units included in the pay
period, if the pay unit of measure is of
type U (units).
ABN-PAY-RATE Signed 13.4
Rate of Pay The pay rate used in calculations.
ABN-PAY-OT-RATE Signed 13.4
Pay Ot Rate
ABN-PAY-UOM Alpha 12
Pay Uom The pay unit of measure used in the
calculations. If it is of type H
(hours), it is multiplied by the number
of hours. If it is of type U (units), it
is multiplied by the number of units.
The unit of measures are defined on
Units of Measure (AC17.1).
ABN-WAGE-AMOUNT Signed 13.2
Wage Amount The wage amount for the pay period,
calculated as follows:
- If the unit of measure is of type H,
the wage amount is equal to PAY-RATE *
PAY-HOURS.
- If the unit of measure is of type U,
the wage amount is equal to PAY-RATE *
PAY-UNITS.
ABN-BILL-HOURS Signed 7.2
Bill Hours The bill hours included in the pay
period, if the bill unit of measure is
of type H (hours).
ABN-BILL-UNITS Signed 7.2
Bill Units The bill units included in the pay
period, if the bill unit of measure is
of type U (units).
ABN-BILL-RATE Signed 13.4
Bill Rate The bill rate used in calculations.
ABN-BILL-OT-RATE Signed 13.4
Bill Ot Rate
ABN-BILL-UOM Alpha 12
Bill Uom The bill units of measure used in the
calculations. If it is of type H
(hours), it is multiplied by the number
of hours. If it is of type U (units), it
is multiplied by the number of units.
The unit of measures are defined on
Units of Measure (AC17.1).
ABN-AR-COMPANY Numeric 4
Ar Company The Accounts Receivable company for the
customer associated with the assignment.
ABN-CUSTOMER Alpha 9 (Right Justified)
Customer Number The customer associated with the
assignment.
ABN-BILLABLE-AMT Signed 15.2
Billable Amt The wage amount for the bill period,
calculated as follows:
- If the unit of measure is of type H,
the billable amount is equal to
BILL-RATE * BILL -HOURS.
- If the unit of measure is of type U,
the billable amount is equal to BILL
-RATE * BILL -UNITS.
ABN-BILLED Alpha 1
Billed Indicates whether the record has been
sent to the Consolidated Invoicing
system (CN) for invoicing. Valid values
are:
Y = Yes
N = No
ABN-CHECK-ID Numeric 12 AC542 PR195
Internal Check ID This field contains the Check ID value PR197 PR82.1
Number from the PRTIME file. It is needed to PR85.1
create a relationship from ABTRANS to
PRTIME in order to drill from an ABTRANS
record to the check that paid it in the
Payroll system.
ABN-TIMECARD-NBR Numeric 12
Timecard Nbr Time Card number to provide an audit
trail back to the original source
document.
ABN-FICA-NBR Alpha 15
Social Security Social Security number for the
Number employee. It is being stored here to be
used as a sort for the Time Entry
screens.
ABN-EMP-FMT-NAME Alpha 30 (Lower Case)
Emp Fmt Name Concatenation of the employee's last
name, first name and middle initial. It
is being stored here instead of just
being read from EMPLOYEE file
information because it is needed as a
sort for the Time Entry screens.
ABN-RECORD-TYPE Alpha 1
Record Type The transaction record type. Valid
values are:
B = Bill Only
P = Pay Only
T = Both Pay and Bill
ABN-ATN-OBJ-ID Numeric 12
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
ABN-GLT-OBJ-ID Numeric 12
Subsystem GL This is a subsystem GL interface
Interface ID identification number. It is used for
Drill Around purposes.
ABN-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
ABN-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
ABN-SHIFT Numeric 1
Shift Contains the shift number associated
with the pay.
ABN-MAINT-DATE Numeric 8 (yyyymmdd)
Maintenance Date The date last changed.
ABN-MAINT-TIME Numeric 6 (hhmmss)
Maintenance Time The time last changed.
ABN-PROD-TAX-CAT Alpha 15
Product Tax Category A classification of items for
determining taxes using the VERTEX
system in Lawson Order Entry system or
the cash receipts programs in the Lawson
Cash Ledger system.
ABN-TAX-CODE Alpha 10
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
ABN-TAX-EXEMPT-CD Alpha 1
Tax Exempt Code
ABN-PAY-SUM-GRP Alpha 3
Payment Summary
Group
ABN-XREF-COMPANY Numeric 4
Xref Company
ABN-XREF-TYPE Alpha 1
Xref Type
ABN-XREF-NBR Alpha 22
Xref Nbr
ABN-USER-ID Alpha 10 (Lower Case)
User ID Name Contains the user ID of the person who
last changed this record.
ABN-DATE-STAMP Numeric 8 (yyyymmdd)
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
ABN-EXP-COMPANY Numeric 4
Exp Company
ABN-EXP-ACCT-UNIT Alpha 15
Expense Accounting The general ledger distribution
Unit accounting unit.
ABN-EXP-ACCOUNT Numeric 6
Expense Account The general ledger distribution account
number.
ABN-EXP-SUB-ACCT Numeric 4
Depr Expense The general ledger distribution
Subaccount subaccount number.
ABN-REV-COMPANY Numeric 4
Rev Company
ABN-REV-ACCT-UNIT Alpha 15
Rev Acct Unit The general ledger revenue (sales)
accounting unit for the company-process
level assigned to the category.
ABN-REV-ACCOUNT Numeric 6
Rev Account This field represents the general
ledger revenue (sales) account for the
category.
ABN-REV-SUB-ACCT Numeric 4
Rev Sub Acct The general ledger revenue (sales)
subaccount for the category.
ABTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABNSET1 OBJ-ID This index retrieves transaction AC542 PR160
information by transaction object ID. PR180 PR195
PR197 PR80.2
PR82.1 PR85.1
ABNSET10 ASSIGNMENT KeyChange
TR-DATE
OBJ-ID
ABNSET2 HR-COMPANY This index retrieves transaction
EMPLOYEE-TYPE information by HR company, employee, and
EMPLOYEE time record sequence number.
TIME-SEQ KeyChange
OBJ-ID
ABNSET3 HR-COMPANY This index retrieves transaction
PR-PROCESS-LVLinformation by HR company, process
DEPARTMENT level, department, and employee number.
EMPLOYEE KeyChange
EMPLOYEE-TYPE
WRK-END-DATE
TR-DATE
ASSIGNMENT
PAY-CODE
OBJ-ID
ABNSET4 HR-COMPANY This index retrieves transaction
PR-PROCESS-LVLinformation by HR company, process
DEPARTMENT level, department, and employee name.
EMP-FMT-NAME KeyChange
EMPLOYEE-TYPE
WRK-END-DATE
OBJ-ID
ABNSET5 HR-COMPANY This index retrieves transaction
PR-PROCESS-LVLinformation by. by HR company, process
DEPARTMENT level, department, and social security
FICA-NBR number.
EMPLOYEE-TYPE KeyChange
WRK-END-DATE
OBJ-ID
ABNSET6 AR-COMPANY This index retrieves transaction
CUSTOMER information by. AR company, customer,
EMPLOYEE and employee number
EMPLOYEE-TYPE KeyChange
WRK-END-DATE
OBJ-ID
ABNSET7 AR-COMPANY This index retrieves transaction
CUSTOMER information by AR company, customer, and
EMP-FMT-NAME employee name
WRK-END-DATE KeyChange
OBJ-ID
ABNSET8 AR-COMPANY This index retrieves transaction
CUSTOMER information by AR company, customer, and
FICA-NBR employee social security number
WRK-END-DATE KeyChange
OBJ-ID
ABTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Abassign ABASSIGN Not Required
ABN-ASSIGNMENT -> ASN-ASSIGNMENT (ASNSET1)
Acsubcont ACSUBCONT Required
When ABN-EMPLOYEE-TYPE = "S"
ABN-EMPLOYEE -> SUB-SUBCONT-EMP
Actrans ACTRANS Not Required
ABN-ATN-OBJ-ID -> ATN-OBJ-ID
Arcomp ARCOMP Not Required
ABN-AR-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Not Required
ABN-AR-COMPANY -> ACM-COMPANY
ABN-CUSTOMER -> ACM-CUSTOMER
Cucodes CUCODES Required
ABN-CURRENCY-CODE -> CUC-CURRENCY-CODE
Deptcode DEPTCODE Required
ABN-HR-COMPANY -> DPT-COMPANY
ABN-PR-PROCESS-LVL -> DPT-PROCESS-LEVEL
ABN-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Not Required
Valid When (ABN-EMPLOYEE-TYPE = "E" )
ABN-HR-COMPANY -> EMP-COMPANY
ABN-EMPLOYEE -> EMP-EMPLOYEE
Gltrans GLTRANS Not Required
ABN-GLT-OBJ-ID -> GLT-OBJ-ID
Prcheck PRCHECK Not Required
ABN-HR-COMPANY -> PCH-COMPANY
ABN-CHECK-ID -> PCH-CHECK-ID
Prsystem Comp PRSYSTEM Required
ABN-HR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Prsystem Proc PRSYSTEM Required
ABN-HR-COMPANY -> PRS-COMPANY
ABN-PR-PROCESS-LVL -> PRS-PROCESS-LEVEL
Prtime PRTIME Not Required
ABN-HR-COMPANY -> PRT-COMPANY
ABN-EMPLOYEE -> PRT-EMPLOYEE
ABN-TR-DATE -> PRT-TR-DATE
ABN-TIME-SEQ -> PRT-TIME-SEQ
ABN-CHECK-ID -> PRT-CHECK-ID
Timerecord TIMERECORD Not Required
ABN-HR-COMPANY -> TRD-COMPANY
ABN-EMPLOYEE -> TRD-EMPLOYEE
ABN-TIME-SEQ -> TRD-TIME-SEQ
|
