| DAYENDSEQ |
BCD*10.0 |
Day End Number |
|
| CRNAHSEQ |
BCD*10.0 |
Processing Sequence |
|
| CRNASSEQ |
BCD*10.0 |
Cost Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| TRANSTYPE |
Integer |
Transaction Type |
|
| INVNUMBER |
String*22 |
Invoice Number |
Mask: %-22C |
| PONUMBER |
String*22 |
Purchase Order Number |
Mask: %-22C |
| RCPNUMBER |
String*22 |
Receipt Number |
Mask: %-22C |
| CRNNUMBER |
String*22 |
Credit/Debit Note Number |
Mask: %-22C |
| ADDCOST |
String*6 |
Additional Cost |
Mask: %-6N |
| DESCRIPTIO |
String*60 |
Description |
|
| PRORMETHOD |
Integer |
Proration Method |
List: 5 entries
| 1 | = | No Proration | | 2 | = | Prorate by Quantity | | 3 | = | Prorate by Cost | | 4 | = | Prorate by Weight | | 5 | = | Prorate Manually |
|
| REPRORATE |
Integer |
Reproration Method |
List: 3 entries
| 1 | = | Leave | | 2 | = | Prorate | | 3 | = | Expense |
|
| VENDOR |
String*12 |
Vendor |
Mask: %-12C |
| VENDORNAME |
String*60 |
Name |
|
| TAXGROUP |
String*12 |
Tax Group |
Mask: %-12N |
| TAXAUTH1 |
String*12 |
Tax Authority 1 |
|
| TAXAUTH2 |
String*12 |
Tax Authority 2 |
|
| TAXAUTH3 |
String*12 |
Tax Authority 3 |
|
| TAXAUTH4 |
String*12 |
Tax Authority 4 |
|
| TAXAUTH5 |
String*12 |
Tax Authority 5 |
|
| TAXVCLASS1 |
Integer |
Vendor Tax Class 1 |
|
| TAXVCLASS2 |
Integer |
Vendor Tax Class 2 |
|
| TAXVCLASS3 |
Integer |
Vendor Tax Class 3 |
|
| TAXVCLASS4 |
Integer |
Vendor Tax Class 4 |
|
| TAXVCLASS5 |
Integer |
Vendor Tax Class 5 |
|
| TAXICLASS1 |
Integer |
Cost Tax Class 1 |
|
| TAXICLASS2 |
Integer |
Cost Tax Class 2 |
|
| TAXICLASS3 |
Integer |
Cost Tax Class 3 |
|
| TAXICLASS4 |
Integer |
Cost Tax Class 4 |
|
| TAXICLASS5 |
Integer |
Cost Tax Class 5 |
|
| CURRENCY |
String*3 |
Currency |
Mask: %-3N |
| EXRATE |
BCD*8.7 |
Exchange Rate |
|
| RATEDATE |
Date |
Rate Date |
|
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| RATEOPER |
Integer |
Rate Operation |
List: 2 entries
|
| RATEOVER |
Boolean |
Rate Overridden |
List: 2 entries
|
| SCURNDECML |
Integer |
Decimal Places |
|
| GLEXPACCT |
String*45 |
Expense Account |
Mask: %-45C |
| GLRETACCT |
String*45 |
Return Account |
Mask: %-45C |
| FCAMOUNT |
BCD*10.3 |
Conversion Functional Amount |
|
| SCAMOUNT |
BCD*10.3 |
Conversion Source Amount |
|
| FCBASEALLO |
BCD*10.3 |
Func. Base to Allocate |
|
| SCBASEALLO |
BCD*10.3 |
Base to Allocate |
|
| FCTAXALLO |
BCD*10.3 |
Func. Total Tax Allocated |
|
| SCTAXALLO |
BCD*10.3 |
Total Tax Allocated |
|
| FCTAXINCL |
BCD*10.3 |
Func. Tax Included in Price |
|
| SCTAXINCL |
BCD*10.3 |
Tax Included in Price |
|
| FCTAXEXCL |
BCD*10.3 |
Func. Tax Excluded from Price |
|
| SCTAXEXCL |
BCD*10.3 |
Tax Excluded from Price |
|
| TAXBASE1 |
BCD*10.3 |
Tax Base 1 |
|
| TAXBASE2 |
BCD*10.3 |
Tax Base 2 |
|
| TAXBASE3 |
BCD*10.3 |
Tax Base 3 |
|
| TAXBASE4 |
BCD*10.3 |
Tax Base 4 |
|
| TAXBASE5 |
BCD*10.3 |
Tax Base 5 |
|
| TAXINCLUD1 |
Boolean |
Tax Includable 1 |
List: 2 entries
|
| TAXINCLUD2 |
Boolean |
Tax Includable 2 |
List: 2 entries
|
| TAXINCLUD3 |
Boolean |
Tax Includable 3 |
List: 2 entries
|
| TAXINCLUD4 |
Boolean |
Tax Includable 4 |
List: 2 entries
|
| TAXINCLUD5 |
Boolean |
Tax Includable 5 |
List: 2 entries
|
| TAXAMOUNT1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAXAMOUNT2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAXAMOUNT3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAXAMOUNT4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAXAMOUNT5 |
BCD*10.3 |
Tax Amount 5 |
|
| TXRECVAMT1 |
BCD*10.3 |
Tax Recoverable Amount 1 |
|
| TXRECVAMT2 |
BCD*10.3 |
Tax Recoverable Amount 2 |
|
| TXRECVAMT3 |
BCD*10.3 |
Tax Recoverable Amount 3 |
|
| TXRECVAMT4 |
BCD*10.3 |
Tax Recoverable Amount 4 |
|
| TXRECVAMT5 |
BCD*10.3 |
Tax Recoverable Amount 5 |
|
| TXEXPSAMT1 |
BCD*10.3 |
Tax Expense Amount 1 |
|
| TXEXPSAMT2 |
BCD*10.3 |
Tax Expense Amount 2 |
|
| TXEXPSAMT3 |
BCD*10.3 |
Tax Expense Amount 3 |
|
| TXEXPSAMT4 |
BCD*10.3 |
Tax Expense Amount 4 |
|
| TXEXPSAMT5 |
BCD*10.3 |
Tax Expense Amount 5 |
|
| INVSSEQG |
BCD*10.0 |
Invoice Cost Group Sequence |
|
| VALUES |
Long |
Optional Fields |
|
| RCPSSEQ |
BCD*10.0 |
Receipt Cost Sequence |
|
| INVSSEQ |
BCD*10.0 |
Invoice Cost Sequence |
|
| CRNSSEQ |
BCD*10.0 |
Credit/Debit Note Cost Sequence |
|
| FCTAXRECV |
BCD*10.3 |
Func. Total Tax Recoverable |
|
| SCTAXRECV |
BCD*10.3 |
Total Tax Recoverable |
|
| FCTAXEXPS |
BCD*10.3 |
Func. Total Tax Expensed |
|
| SCTAXEXPS |
BCD*10.3 |
Total Tax Expensed |
|
| FCTAXAMT1 |
BCD*10.3 |
Func. Tax Amount 1 |
|
| FCTAXAMT2 |
BCD*10.3 |
Func. Tax Amount 2 |
|
| FCTAXAMT3 |
BCD*10.3 |
Func. Tax Amount 3 |
|
| FCTAXAMT4 |
BCD*10.3 |
Func. Tax Amount 4 |
|
| FCTAXAMT5 |
BCD*10.3 |
Func. Tax Amount 5 |
|
| GLNOPRORCR |
String*45 |
Expensed Add'l Cost Clr. Acct. |
Mask: %-45C |
| NOPRORTOGL |
Boolean |
Exp. Add'l Cost G/L data posted? |
List: 2 entries
|
| COMMENT |
String*250 |
Comment |
|
| CONTRACT |
String*16 |
Contract |
Mask: %-16C |
| PROJECT |
String*16 |
Project |
Mask: %-16N |
| CCATEGORY |
String*16 |
(Cost) Category |
Mask: %-16N |
| COSTCLASS |
Integer |
Cost Class |
List: 7 entries
| 0 | = | | | 1 | = | Labor | | 2 | = | Material | | 3 | = | Equipment | | 4 | = | Subcontractor | | 5 | = | Overhead | | 6 | = | Miscellaneous |
|
| RESOURCE |
String*24 |
Resource |
Mask: %-24C |
| BILLTYPE |
Integer |
Billing Type |
List: 4 entries
| 0 | = | | | 1 | = | Non-billable | | 2 | = | Billable | | 3 | = | No Charge |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| BILLCURR |
String*3 |
Billing Currency |
Mask: %-3N |
| ARITEMNO |
String*16 |
A/R Item Number |
Mask: %-16C |
| ARUNIT |
String*10 |
A/R Unit of Measure |
Mask: %-10C |
| CALCOVRHD |
Boolean |
Calculate Overhead |
List: 2 entries
|
| CALCLABOR |
Boolean |
Calculate Labor |
List: 2 entries
|
| HASRTG |
Boolean |
Has Retainage |
List: 2 entries
|
| RTGRATE |
Integer |
Retainage Exchange Rate |
List: 2 entries
| 0 | = | Use Original Document Exchange Rate | | 1 | = | Use Current Exchange Rate |
|
| RTGPERCENT |
BCD*5.5 |
Retainage Percentage |
|
| RTGDAYS |
Integer |
Retention Period |
|
| SCRTGAMT |
BCD*10.3 |
Retainage Amount |
|
| FCRTGAMTOT |
BCD*10.3 |
Func. Total Retainage Amount |
|
| SCRTGAMTOT |
BCD*10.3 |
Total Retainage Amount |
|
| RTGDATEDUE |
Date |
Retainage Due Date |
|
| RTGAMTOVER |
Boolean |
Retainage Amount Overridden |
List: 2 entries
|
| RTGDDTOVER |
Boolean |
Retainage Due Date Overridden |
List: 2 entries
|
| GLOVERHEAD |
String*45 |
Overhead Account |
Mask: %-45C |
| GLLABOR |
String*45 |
Labor Burden Account |
Mask: %-45C |
| FCOVRHDAMT |
BCD*10.3 |
Func. Overhead Amount |
|
| SCOVRHDAMT |
BCD*10.3 |
Overhead Amount |
|
| FCLABORAMT |
BCD*10.3 |
Func. Labor Burden Amount |
|
| SCLABORAMT |
BCD*10.3 |
Labor Burden Amount |
|
| PMTRANSNUM |
Long |
PJC Transaction Number |
|
| TRCURRENCY |
String*3 |
Tax Reporting Currency |
Mask: %-3N |
| EXRATERC |
BCD*8.7 |
Tax Reporting Exchange Rate |
|
| RATEDATERC |
Date |
Tax Reporting Rate Date |
|
| RATETYPERC |
String*2 |
Tax Reporting Rate Type |
Mask: %-2N |
| RATEOPERRC |
Integer |
Tax Reporting Rate Operation |
List: 2 entries
|
| RATERCOVER |
Boolean |
Tax Reporting Rate Overridden |
List: 2 entries
|
| RCURNDECML |
Integer |
Tax Reporting Decimal Places |
|
| RCTAXALLO |
BCD*10.3 |
Rptg. Total Tax Allocated |
|
| RCTAXRECV |
BCD*10.3 |
Rptg. Total Tax Recoverable |
|
| RCTAXEXPS |
BCD*10.3 |
Rptg. Total Tax Expensed |
|
| RCTAXINCL |
BCD*10.3 |
Rptg. Total Tax Included |
|
| TARAMOUNT1 |
BCD*10.3 |
Tax Reporting Amount 1 |
|
| TARAMOUNT2 |
BCD*10.3 |
Tax Reporting Amount 2 |
|
| TARAMOUNT3 |
BCD*10.3 |
Tax Reporting Amount 3 |
|
| TARAMOUNT4 |
BCD*10.3 |
Tax Reporting Amount 4 |
|
| TARAMOUNT5 |
BCD*10.3 |
Tax Reporting Amount 5 |
|
| FCAPAMOUNT |
BCD*10.3 |
Func. A/P Amount |
|
| SCRAXALLO |
BCD*10.3 |
Total Rtg. Tax Allocated |
|
| FCRAXALLO |
BCD*10.3 |
Func. Total Rtg. Tax Allocated |
|
| SCRAXEXPS |
BCD*10.3 |
Total Rtg. Tax Expensed |
|
| FCRAXEXPS |
BCD*10.3 |
Func. Total Rtg. Tax Expensed |
|
| RFAPALLO |
BCD*10.3 |
Func. A/P Retainage Tax Allocd. |
|
| RFAPEXPS |
BCD*10.3 |
Func. A/P Retainage Tax Expensed |
|
| RFAPAMT1 |
BCD*10.3 |
Func. A/P Retainage Tax Amount 1 |
|
| RFAPAMT2 |
BCD*10.3 |
Func. A/P Retainage Tax Amount 2 |
|
| RFAPAMT3 |
BCD*10.3 |
Func. A/P Retainage Tax Amount 3 |
|
| RFAPAMT4 |
BCD*10.3 |
Func. A/P Retainage Tax Amount 4 |
|
| RFAPAMT5 |
BCD*10.3 |
Func. A/P Retainage Tax Amount 5 |
|
|