Module List >
Module Olympic PC tables
pc10000
You are currently viewing the COMPANY
database.
Change
|
COMPANY..pc10000 Table Definition
(COMPANY..pcTransaction )
The pc10000 is the Project Cost Transactions Table. These record contain Actual Cost and Revenue details.
Field Definitions:
What is the 'source' column?
| zProjectID |
char(21)
''
|
|
|
|
|
| zTaskID |
char(21)
''
|
|
|
|
|
| zTransactionNumber |
int
0
|
|
|
|
|
| zTransactionDate |
datetime
'1/1/1900'
|
|
|
|
|
| zUserID |
char(15)
''
|
|
|
|
|
| zCostCategoryDDL |
smallint
0
|
1 = Nonebr...(more) Join Now
|
|
|
|
| zCostCategoryString |
char(15)
''
|
|
|
|
|
| zSubCostCategory |
smallint
0
|
|
|
|
|
| zSubCostCategoryString |
char(15)
''
|
|
|
|
|
| zDepartmentID |
char
''
|
|
|
|
|
| zJournalEntry |
int
0
|
|
|
|
|
| zPostingDate |
datetime
'1/1/1900'
|
|
|
|
|
| zSalesJournalEntry |
int
0
|
|
|
|
|
| zSalesPostingDate |
datetime
'1/1/1900'
|
|
|
|
|
| zRecurringTrxSequence |
smallint
0
|
|
|
|
|
| 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)
''
|
|
|
|
|
| zSalesSourceDoc |
char
''
|
|
|
|
|
| zWebSource |
smallint
0
|
|
|
|
|
| zOrigDocumentNumber |
char(21)
''
|
|
|
|
|
| zOrigDocumentDate |
datetime
'1/1/1900'
|
|
|
|
|
| zOrigID |
char(21)
''
|
|
|
|
|
| zOrigName |
char(65)
''
|
|
|
|
|
| zExpenseStatusDDL |
smallint
0
|
|
|
|
|
| zApprovalUserIDCost |
char(15)
''
|
|
|
|
|
| zWorkFlowCostStatusDDL |
smallint
0
|
|
|
|
|
| zAccountIndex |
int
0
|
|
|
|
|
| zAccountNumberString |
char(41)
''
|
|
|
|
|
| zBillingStatusDDL |
smallint
0
|
|
|
|
|
| zApprovalUserIDBilling |
char(15)
''
|
|
|
|
|
| zBillingWorkQty |
numeric(19,5)
0.00
|
|
|
|
|
| zWorkFlowBillStatusDDL |
smallint
0
|
|
|
|
|
| zBillingWorkAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zQty |
numeric(19,5)
0.00
|
|
|
|
|
| zQtyBilled |
numeric(19,5)
0.00
|
|
|
|
|
| zUnitCost |
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
|
|
|
|
|
| zTotalTimeStatusDDL |
smallint
0
|
|
|
|
|
| zPayRecord |
char(7)
''
|
|
|
|
|
| zItemID |
char(31)
''
|
|
|
|
|
| zItemDescription |
char(51)
''
|
|
|
|
|
| zUofM |
char(9)
''
|
|
|
|
See I... more text available
|
| zItemQty |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenStatusDDL |
smallint
0
|
|
|
|
|
| zUserDefinedDate |
datetime
'1/1/1900'
|
|
|
|
|
| zUserDefinedDate2 |
datetime
'1/1/1900'
|
|
|
|
|
| zUserDefinedString |
char(21)
''
|
|
|
|
|
| zUserDefinedString2 |
char(21)
''
|
|
|
|
|
| zUserDefinedCurrency |
numeric(19,5)
0.00
|
|
|
|
|
| zUserDefinedCurrency2 |
numeric(19,5)
0.00
|
|
|
|
|
| zNoteIndex |
numeric(19,5)
0.00
|
|
|
|
|
| zImported |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| zImportType |
smallint
0
|
|
|
|
|
| zOpenForApproval |
tinyint
0
|
|
|
|
|
| zBillingDescriptionText |
varchar
''
|
|
|
|
|
|