Payroll Maintenance
Payroll Projection / Payroll Commitment (Adjustments)
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
Adjustment Amount | COMMIT_ADJUST_HISTORY | ADJUSTMENT_AMOUNT | Size: 10 Format: ########.## |
Adjustment Type Description | COMMIT_ADJUST_HISTORY | ADJUSTMENT_TYPE_DESC | Internal Lookup: Earnings, Banking, Deduction Employers Share, Size: 30 |
Applicable Year | COMMIT_ADJUST_HISTORY | YEAR | Size: 6 |
Balance Before Adjustment | COMMIT_ADJUST_HISTORY | BEFORE_ADJUSTMENT | Size: 10 Format: ########.## |
Data file key number | COMMIT_ADJUST_HISTORY | SEQUENCE_NO | used to identify each record- internal technical field Size: 10 |
Date of Adjustment | COMMIT_ADJUST_HISTORY | ADJUSTMENT_DATE | Size: 11 Format: DD-MMM-YYYY |
General Ledger Account Number | COMMIT_ADJUST_HISTORY | GL_ACCT_NO | Size: 20 |
General Ledger Account Number | COMMIT_ADJUST_HISTORY | GL_ACCT_NO_FORMATTED | Formatted Size: 20 |
Pay or Deduction Code | COMMIT_ADJUST_HISTORY | NUMBER_CODE | Size: 4 |
Sib-Ledger Account Number | COMMIT_ADJUST_HISTORY | SL_ACCT_NO | Size: 10 |
Sib-Ledger Account Number | COMMIT_ADJUST_HISTORY | SL_ACCT_NO_FORMATTED | Formatted Size: 10 |
Storage Bank Code | COMMIT_ADJUST_HISTORY | STORAGE_BANK_CODE | Size: 10 |
Storage Bank Description | COMMIT_ADJUST_HISTORY | STORAGE_BANK_DESC | Size: 30 |
Transaction Type | COMMIT_ADJUST_HISTORY | ADJUSTMENT_TYPE | A=Earnings, B=Banking, D=Deduction Employers Share, Size: 4 |
Payroll Projection / Payroll Commitment (De-commitments)
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
Adjustment Amount | DECOMMITMENT_HISTORY | ADJUST_DECOMMITMENT | Size: 10 Format: ########.## |
Applicable Year | DECOMMITMENT_HISTORY | YEAR | Size: 4 |
Balance prior to De-commitment | DECOMMITMENT_HISTORY | BEFORE_DECOMMITMENT | Size: 10 Format: ########.## |
Data file key number | DECOMMITMENT_HISTORY | SEQUENCE_NO | used to identify each record- internal technical field Size: 10 |
Date of De-commitment | DECOMMITMENT_HISTORY | DECOMMITMENT_DATE | Size: 11 Format: DD-MMM-YYYY |
De-commitment Type | DECOMMITMENT_HISTORY | DECOMMITMENT_TYPE | [P/B/D] P = Pay; B = Bank; D = Deduction (MA, MB, MD) Size: 4 |
De-commitment Type Description | DECOMMITMENT_HISTORY | DECOMMITMENT_TYPE_DESC | Internal Lookup: Earnings, Banking, Deduction Employers Share Size: 30 |
General Ledger Account Number | DECOMMITMENT_HISTORY | GL_ACCT_NO | Size: 20 |
General Ledger Account Number | DECOMMITMENT_HISTORY | GL_ACCT_NO_FORMATTED | Formatted Size: 20 |
New Current De-commitment Amount | DECOMMITMENT_HISTORY | DECOMMITMENT_AMOUNT | Size: 10 Format: ########.## |
Pay or Deduction Code | DECOMMITMENT_HISTORY | NUMBER_CODE | Size: 4 |
Storage Bank Code | DECOMMITMENT_HISTORY | STORAGE_BANK_CODE | Size: 10 |
Storage Bank Description | DECOMMITMENT_HISTORY | STORAGE_BANK_DESC | Size: 30 |
Sub-Ledger Account Number | DECOMMITMENT_HISTORY | SL_ACCT_NO | Size: 10 |
Sub-Ledger Account Number | DECOMMITMENT_HISTORY | SL_ACCT_NO_FORMATTED | Formatted Size: 10 |
Payroll Projection / Payroll Commitment / Project
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
Amount Adjusted | COMMITMENT_HISTORY | ADJUSTMENTS_AMOUNT | Size: 10 Format: ########.## |
Commitment Type | COMMITMENT_HISTORY | COMMITMENT_TYPE | A=Earnings, B=Banking, D=Deduction Employers Share, Size: 4 |
Commitment Type Description | COMMITMENT_HISTORY | COMMITMENT_TYPE_DESC | Internal Lookup: Earnings=Earnings, Banking=Banking, Deduction Employers Share=Deduction Employers Share, Size: 30 |
Data file key number | COMMITMENT_HISTORY | SEQUENCE_NO | used to identify each record- internal technical field Size: 10 |
De-commitment to date amount | COMMITMENT_HISTORY | DECOMMITMENT_AMOUNT | Size: 10 Format: ########.## |
Expensed to Date Amount | COMMITMENT_HISTORY | EXPENSED_AMOUNT | Size: 10 Format: ########.## |
General Ledger Account Number | COMMITMENT_HISTORY | GL_ACCT_NO | Size: 20 |
General Ledger Account Number | COMMITMENT_HISTORY | GL_ACCT_NO_FORMATTED | Formatted Size: 20 |
Number Code | COMMITMENT_HISTORY | NUMBER_CODE | Earnings, Storage Bank (pay code) or Deduction code Size: 4 |
Original Commitment Amount | COMMITMENT_HISTORY | ORIGINAL_COMMITMENT | Size: 10 Format: ########.## |
Storage Bank Code | COMMITMENT_HISTORY | STORAGE_BANK_CODE | Size: 10 |
Storage Bank Description | COMMITMENT_HISTORY | STORAGE_BANK_DESC | Size: 30 |
Sub-Ledger Account Number | COMMITMENT_HISTORY | SL_ACCT_NO | Size: 10 |
Sub-Ledger Account Number | COMMITMENT_HISTORY | SL_ACCT_NO_FORMATTED | Fomatted Size: 10 |
Year applicable for commitment | COMMITMENT_HISTORY | YEAR | Size: 6 |