|
|
ABASSIGN FILE
The Assignment Billing Assignment file is the primary setup file for the
Assignment Billing application. It stores the job assignment information,
including general information about the assignment, billing and pay
information needed for invoicing and time entry, and sales rep information.
The Attachment option is enabled for this file so that comments can be added
and stored for assignments.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASN-ASSIGNMENT Alpha 15
Element: Assignment The assignment number or identifier
that links a candidate with a job
request.
ASN-DESCRIPTION Alpha 30 (Lower Case)
Element: Description The assignment number description.
ASN-COMPANY Numeric 4
Element: Company The company responsible for the
assignment. Security for the assignment
is set at the company and accounting
unit level.
ASN-ACCT-UNIT Alpha 15
Element: Accounting UniThe accounting unit responsible for the
assignment. Security for the assignment
is set at the company and accounting
unit level.
ASN-AR-COMPANY Numeric 4
Element: Ar Company The Accounts Receivable company for the
customer being matched with an employee
for the assignment.
ASN-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThe Accounts Receivable customer being
matched with an employee for the
assignment.
ASN-AR-PROCESS-LVL Alpha 5
Element: Ar Process LvlThe Accounts Receivable process level
to be used for the assignment.
ASN-HR-COMPANY Numeric 4
Element: Company The Human Resources (HR) company for
the employee being matched with the
customer for the assignment.
ASN-EMPLOYEE-TYPE Alpha 1
Element: Employee Type The employee type. Valid values are:
E = Employee
S = Subcontract Employee
ASN-EMPLOYEE Numeric 9
Element: Employee The employee matched with the customer
for the assignment. It must be a valid
employee number set up in the Payroll
(PR) application.
ASN-PR-PROCESS-LVL Alpha 5
Element: Pr Process LvlThe PR process level assigned to the
employee.
ASN-DEPARTMENT Alpha 5
Element: Department The department to which the employee is
assigned.
ASN-LOCAT-CODE Alpha 10
Element: Location The location code for the Payroll Tax
Locator
ASN-BEGIN-DATE Numeric 8 (yyyymmdd)
Element: Date The begin date for the assignment. This
field is required.
ASN-END-DATE Numeric 8 (yyyymmdd)
Element: Date The end date for the assignment. This
field is optional.
ASN-CUST-PO-NBR Alpha 22
Element: Customer P.O. The customer's PO or work order number
from the job request.
ASN-JOB-CODE Alpha 9
Element: Job Code The employee's job code. Must be a
valid code in the Payroll application
ASN-JOB-CODE-DESC Alpha 30 (Lower Case)
Element: Job Code Desc The job code description.
ASN-ACTIVITY Alpha 15
Element: Activity The activity to which all cost and
revenue amounts for the assignment will
be posted. Must be a valid activity in
the Project and Activity Accounting (AC)
application.
ASN-COST-ACCT-CAT Alpha 5
Element: Cost Acct Cat The account category used when posting
costs to Project and Activity Accounting
for this assignment.
ASN-EXP-COMPANY Numeric 4
Element: Exp Company The company used to post expenses.
ASN-EXP-ACCT-UNIT Alpha 15
Element: Accounting UniThe accounting unit used to post
expenses.
ASN-EXP-ACCOUNT Numeric 6
Element: Account The account used to post expenses.
ASN-EXP-SUB-ACCT Numeric 4
Element: Subaccount The subaccount used to post expenses.
ASN-REV-ACCT-CAT Alpha 5
Element: Account CategoThe account category used when posting
revenue to Project and Activity
Accounting for this assignment.
ASN-REV-COMPANY Numeric 4
Element: Rev Company The company used to post revenue.
ASN-REV-ACCT-UNIT Alpha 15
Element: Accounting UniThe accounting unit used to post
revenue.
ASN-REV-ACCOUNT Numeric 6
Element: Account The account used to post revenue.
ASN-REV-SUB-ACCT Numeric 4
Element: Subaccount The subaccount used to post revenue.
ASN-TAX-CODE Alpha 10
Element: Tax Code The tax code used if the billing amount
is taxable. Must be a valid tax code in
the Tax system.
ASN-TAX-EXEMPT-CD Alpha 1
Element: Tax Exempt CodThe tax exemption status. Valid values
are:
E = Exempt
T = Taxable
ASN-OBJ-ID Numeric 12
Object A unique identifier for the assignment,
Identification used to relate to other files.
ASN-ASSIGN-PCT-BAL Signed 7.4
Element: Assign Pct BalThis is used to store the total of the
sales representatives percentages in
order to edit that the total does not
exceed 100% for all sales
representatives for an assignment.
ASN-BILL-TO Numeric 4
Element: Ship-to Code
ASN-AR-CODE Alpha 4
Accounts Receivable
Code
ASN-TERMS-CD Alpha 5
Element: Terms Code
ASN-OFFSET-CODE Alpha 4
Accounts Receivable
Code
ASN-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.
ASN-CUST-DELIV-TO Alpha 15 (Right Justified)
Element: Cust Deliv To
ASN-TIME-REC-FREQ Alpha 1
Element: Time Rec Freq W = Weekly
D = Daily
ASN-RECORD-TYPE Alpha 1
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
P = Pay Only
B = Bill Only
T = Both
ABASSIGN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASNSET1 ASSIGNMENT This index is used to retrieve
assignment information by assignment.
ASNSET2 AR-COMPANY This index is used to retrieve
CUSTOMER assignment information by AR company,
ASSIGNMENT and customer.
KeyChange
ASNSET4 EMPLOYEE-TYPE This index is used to retrieve
HR-COMPANY assignment information by employee type,
EMPLOYEE HR company, and employee.
ASSIGNMENT KeyChange
ASNSET5 OBJ-ID This index is used to retrieve
assignment information by object ID.
ASNSET6 HR-COMPANY This index is used to retrieve
PR-PROCESS-LVLassignment information by HR company, PR
DEPARTMENT process level, and department.
ASSIGNMENT KeyChange
ASNSET7 EMPLOYEE-TYPE KeyChange, Subset
EMPLOYEE Where EMPLOYEE-TYPE = "S"
ASSIGNMENT
ABASSIGN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
ASN-ACTIVITY -> -ACTIVITY (XXXXXXXXXX)
Acsubcont ACSUBCONT Required
When ASN-EMPLOYEE-TYPE = "S"
ASN-EMPLOYEE -> SUB-SUBCONT-EMP
Arcode Ar ARCODE Required
ASN-AR-COMPANY -> RCD-COMPANY
ASN-AR-CODE -> RCD-AR-CODE
Arcode Offset ARCODE Required
ASN-AR-COMPANY -> RCD-COMPANY
ASN-OFFSET-CODE -> RCD-AR-CODE
Arcomp ARCOMP Required
ASN-AR-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
ASN-AR-COMPANY -> ACM-COMPANY
ASN-CUSTOMER -> ACM-CUSTOMER
Billto BILLTO Required
ACO-CUST-GROUP -> ABS-CUST-GROUP
ASN-CUSTOMER -> ABS-CUSTOMER
ASN-BILL-TO -> ABS-BILL-TO
Deptcode DEPTCODE Required
ASN-HR-COMPANY -> DPT-COMPANY
ASN-PR-PROCESS-LVL -> DPT-PROCESS-LEVEL
ASN-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
When ASN-EMPLOYEE-TYPE = "E"
ASN-HR-COMPANY -> EMP-COMPANY
ASN-EMPLOYEE -> EMP-EMPLOYEE
Glnames GLNAMES Required
ASN-COMPANY -> GLN-COMPANY
ASN-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
ASN-COMPANY -> GLS-COMPANY
Jobcode JOBCODE Required
ASN-HR-COMPANY -> JBC-COMPANY
ASN-JOB-CODE -> JBC-JOB-CODE
Pcodes PCODES Required
"LO" -> PCO-TYPE
ASN-LOCAT-CODE -> PCO-CODE
Prsystem Comp PRSYSTEM Required
ASN-HR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Prsystem Proc PRSYSTEM Required
ASN-HR-COMPANY -> PRS-COMPANY
ASN-PR-PROCESS-LVL -> PRS-PROCESS-LEVEL
Terms TERMS Required
ASN-TERMS-CD -> TMS-TERMS-CD
Txcodemast TXCODEMAST Required
ASN-TAX-CODE -> TCM-TAX-CODE
Txtaxcode TXTAXCODE Required
ASN-AR-COMPANY -> TAC-COMPANY
ASN-TAX-CODE -> TAC-TAX-CODE
ABASSIGN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Abtrans ABTRANS
ASN-ASSIGNMENT -> ABN-ASSIGNMENT
ABN-TR-DATE
ABN-OBJ-ID
Txtaxrate TXTAXRATE
ASN-TAX-CODE -> TXR-TAX-CODE
ASN-PROD-TAX-CAT -> TXR-PROD-TAX-CAT
TXR-EFFECT-DATE
|
