Module List >
Module Olympic PC tables
pc30000
You are currently viewing the COMPANY
database.
Change
|
COMPANY..pc30000 Table Definition
(COMPANY..pcPOTransaction )
The pc30000 is the Project Purchase Order transaction table.
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
|
Incomplete...(more) Join Now
|
|
|
|
| zCostCategoryString |
char(15)
''
|
|
|
|
|
| zSubCostCategory |
smallint
0
|
|
|
|
|
| zSubCostCategoryString |
char(15)
''
|
|
|
|
|
| zTransactionDescription |
char(61)
''
|
|
|
|
|
| zDepartmentID |
char
''
|
|
|
|
|
| zBillingDescriptionLine1 |
char(51)
''
|
|
|
|
|
| zBillingDescriptionLine2 |
char(51)
''
|
|
|
|
|
| zBillingDescriptionLine3 |
char(51)
''
|
|
|
|
|
| zBillingDescriptionLine4 |
char(51)
''
|
|
|
|
|
| zAccountIndex |
int
0
|
|
|
|
|
| zAccountNumberString |
char(41)
''
|
|
|
|
|
| zPONumber |
char(17)
''
|
|
|
|
|
| zPOLineNumber |
int
0
|
|
|
|
|
| zVendorID |
char(15)
''
|
|
|
|
|
| zQty |
numeric(19,5)
0.00
|
|
|
|
|
| zUnitCost |
numeric(19,5)
0.00
|
|
|
|
|
| zOriginatingUnitCost |
numeric(19,5)
0.00
|
|
|
|
|
| zCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zOriginatingCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zUnitPrice |
numeric(19,5)
0.00
|
|
|
|
|
| zItemID |
char(31)
''
|
|
|
|
|
| zLocationCode |
char
''
|
|
|
|
|
| zItemDescription |
char(51)
''
|
|
|
|
|
| zUofM |
char(9)
''
|
|
|
|
See I... more text available
|
| 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
|
|
|
|
|
| zInventoryIndex |
int
0
|
|
|
|
|
| zQtyReceived |
numeric(19,5)
0.00
|
|
|
|
|
| zQtyInvoiced |
numeric(19,5)
0.00
|
|
|
|
|
| zBillingDescriptionText |
text
''
|
|
|
|
|
| zBudgetTransactionNumber |
int
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|