|
|
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.
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
Element: 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)
Element: Wrk End Date Work period end date in yyyymmdd format.
ABN-TR-DATE Numeric 8 (yyyymmdd)
Element: Time Record DaDate that the work was performed in
yyyymmdd format.
ABN-EMPLOYEE-TYPE Alpha 1
Element: 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
Element: Employee HR or Subcontract employee ID
ABN-TIME-SEQ Numeric 12
Element: Sequence NumbeThis 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
Element: 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
Element: Pr Process LvlThe 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
Element: 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
Element: Pr Status Indicates the status of the ABTRANS
record with regards to Payroll. The
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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Rate of Pay The pay rate used in calculations.
ABN-PAY-OT-RATE Signed 13.4
Element: Pay Ot Rate
ABN-PAY-UOM Alpha 12
Element: 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
Element: 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
Element: 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
Element: 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
Element: Document TotalThe bill rate used in calculations.
ABN-BILL-OT-RATE Signed 13.4
Element: Bill Ot Rate
ABN-BILL-UOM Alpha 12
Element: 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
Element: Ar Company The Accounts Receivable company for the
customer associated with the assignment.
ABN-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThe customer associated with the
assignment.
ABN-BILLABLE-AMT Signed 15.2
Element: Adj 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
Element: All Flag 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
Internal Check ID This field contains the Check ID value
Number from the PRTIME file. It is needed to
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
Element: 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)
Element: 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
Element: 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
Object
Identification
ABN-GLT-OBJ-ID Numeric 12
Object
Identification
ABN-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
ABN-CURR-ND Numeric 1
Account Currency
Code
ABN-SHIFT Numeric 1
Element: Shift Contains the shift number associated
with the pay.
ABN-MAINT-DATE Numeric 8 (yyyymmdd)
Element: Date
ABN-MAINT-TIME Numeric 6 (hhmmss)
Element: Sys Time
ABN-PROD-TAX-CAT Alpha 15
Element: Product Tax CaA 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
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
ABN-TAX-EXEMPT-CD Alpha 1
Element: Tax Exempt Code
ABN-PAY-SUM-GRP Alpha 3
Payment Summary
Group
ABN-XREF-COMPANY Numeric 4
Element: Company
ABN-XREF-TYPE Alpha 1
Element: Xref Type
ABN-XREF-NBR Alpha 22
Element: Xref Nbr
ABN-USER-ID Alpha 10 (Lower Case)
Element: User
ABN-DATE-STAMP Numeric 8 (yyyymmdd)
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
ABN-EXP-COMPANY Numeric 4
Element: Exp Company
ABN-EXP-ACCT-UNIT Alpha 15
Element: Accounting Unit
ABN-EXP-ACCOUNT Numeric 6
Element: Account
ABN-EXP-SUB-ACCT Numeric 4
Element: Subaccount
ABN-REV-COMPANY Numeric 4
Element: Rev Company
ABN-REV-ACCT-UNIT Alpha 15
Element: Accounting Unit
ABN-REV-ACCOUNT Numeric 6
Element: Account
ABN-REV-SUB-ACCT Numeric 4
Element: Subaccount
ABTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABNSET1 OBJ-ID This index retrieves transaction
information by transaction object ID.
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
|
