Module List >
Module Olympic PC tables
pc12000
You are currently viewing the COMPANY
database.
Change
|
COMPANY..pc12000 Table Definition
(COMPANY..pcCrewTransactionHist )
Field Definitions:
What is the 'source' column?
| zCrewID |
char(15)
''
|
|
|
|
|
| zMinimumWageGroup |
char(31)
''
|
|
|
|
|
| zUPRProcessStatusDDL |
smallint
0
|
|
|
|
|
| zProjectID |
char(21)
''
|
|
|
|
|
| zTaskID |
char(21)
''
|
|
|
|
|
| zTransactionNumber |
int
0
|
|
|
|
|
| zAdjustmentNumber |
int
0
|
|
|
|
|
| zTransactionDate |
datetime
'1/1/1900'
|
|
|
|
|
| zUserID |
char(15)
''
|
|
|
|
|
| zCostCategoryDDL |
smallint
0
|
Incomplete...(more) Join Now
|
|
|
|
| zCostCategoryString |
char(15)
''
|
|
|
|
|
| zSubCostCategory |
smallint
0
|
|
|
|
|
| zSubCostCategoryString |
char(15)
''
|
|
|
|
|
| zJournalEntry |
int
0
|
|
|
|
|
| zPostingDate |
datetime
'1/1/1900'
|
|
|
|
|
| zSalesPostingDate |
datetime
'1/1/1900'
|
|
|
|
|
| zPeriodNumber |
int
0
|
|
|
|
|
| zTransactionDescription |
char(61)
''
|
|
|
|
|
| zBillingDescriptionLine1 |
char(51)
''
|
|
|
|
|
| zBillingDescriptionLine2 |
char(51)
''
|
|
|
|
|
| zBillingDescriptionLine3 |
char(51)
''
|
|
|
|
|
| zBillingDescriptionLine4 |
char(51)
''
|
|
|
|
|
| zSalesAccountIndex |
int
0
|
|
|
|
|
| zSalesAccountString |
char(41)
''
|
|
|
|
|
| zDistDocumentTypeDDL |
smallint
0
|
|
|
|
|
| zDistDocumentNumber |
char(21)
''
|
|
|
|
|
| zDistSequenceNumber |
int
0
|
|
|
|
|
| zSalesDocumentTypeDDL |
smallint
0
|
|
|
|
|
| zSalesDocumentNumber |
char(21)
''
|
|
|
|
|
| zSalesLineNumber |
int
0
|
|
|
|
|
| zDistHistoryYear |
smallint
0
|
|
|
|
|
| zSeriesDDL |
smallint
0
|
|
|
|
|
| zSourceDoc |
char(11)
''
|
|
|
|
|
| zWebSource |
smallint
0
|
|
|
|
|
| zOrigDocumentNumber |
char(21)
''
|
|
|
|
|
| zOrigDocumentDate |
datetime
'1/1/1900'
|
|
|
|
|
| zOrigID |
char(21)
''
|
|
|
|
|
| zOrigName |
char(65)
''
|
|
|
|
|
| zExpenseStatusDDL |
smallint
0
|
|
|
|
|
| zApprovalUserIDCost |
char(15)
''
|
|
|
|
|
| zAccountIndex |
int
0
|
|
|
|
|
| zAccountNumberString |
char(41)
''
|
|
|
|
|
| zLaborOffsetAccountIndex |
int
0
|
|
|
|
|
| zLaborOffsetString |
char(41)
''
|
|
|
|
|
| zBillingStatusDDL |
smallint
0
|
|
|
|
|
| zApprovalUserIDBilling |
char(15)
''
|
|
|
|
|
| zBillingWorkQty |
numeric(19,5)
0.00
|
|
|
|
|
| zBillingWorkAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zQty |
numeric(19,5)
0.00
|
|
|
|
|
| zPieceCount |
numeric(19,5)
0.00
|
|
|
|
|
| zPieceRateAmount |
numeric(19,5)
0.00
|
|
|
|
|
| zPieceCountAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zQtyBilled |
numeric(19,5)
0.00
|
|
|
|
|
| zUnitCost |
numeric(19,5)
0.00
|
|
|
|
|
| zMinimumWageRate |
numeric(19,5)
0.00
|
|
|
|
|
| zMinimumWageAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zMinimumWageMakeup |
numeric(19,5)
0.00
|
|
|
|
|
| zMinimumWageFactor |
numeric(19,5)
0.00
|
|
|
|
|
| zCostAmtAdjustment |
numeric(19,5)
0.00
|
|
|
|
|
| zUnitPrice |
numeric(19,5)
0.00
|
|
|
|
|
| zRevenueAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zOriginatingRevenueAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCostAmtEntered |
numeric(19,5)
0.00
|
|
|
|
|
| zCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zOriginatingCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zPayGroupID |
char(15)
''
|
|
|
|
|
| zPayrollStatusDDL |
smallint
0
|
|
|
|
|
| zEmployeeID |
char(15)
''
|
|
|
|
|
| zHoursEntered |
numeric(19,5)
0.00
|
|
|
|
|
| zHoursPaid |
numeric(19,5)
0.00
|
|
|
|
|
| zPayRecord |
char(7)
''
|
|
|
|
|
| zPayRateAmount |
numeric(19,5)
0.00
|
|
|
|
|
| zPayAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zUofM |
char(9)
''
|
|
|
|
See I... more text available
|
| zBurdenStatusDDL |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|