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.
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3