Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column Header Namescolumn lettersRequired field?

Type, Length,

Format

TableDescription
unitAYes


reporterEmailAddressBYes


acquisitionTypeCodeCYesVarchar2VARCHAR2(1)CM_CPTLAST_T
descriptionDYes


organizationOwnerChartOfAccountsCodeEYesVARCHAR(2)CM_CPTLAST_T
organizationOwnerAccountNumberFYesVARCHAR(7)CM_CPTLAST_T
agencyNumberG
VARCHAR2(5)CM_CPTLAST_T
inventoryStatusCodeHYes


conditionCodeIYes


capitalAssetDescriptionJYes


capitalAssetTypeCodeKYes


vendorNameL



manufacturerNameM



manufacturerModelNumberN



organizationTextO



createDatePYes


campusCodeQYes


buildingCodeRYes


buildingRoomNumberS



locationQuantityTYes


serialNumberU



organizationInventoryNameV



organizationAssetTypeIdentifierW



governmentTagNumberX



campusTagNumberY



nationalStockNumberZ



representativeUniversalIdentifierAA



chartOfAccountsCodeABYes


accountNumberACYes


subAccountNumberAD



financialObjectCodeAEYes


financialSubObjectCodeAF



projectCodeAG



organizationReferenceIdAH



expenditureFinancialSystemOriginationCodeAI



expenditureFinancialDocumentNumberAJ



expenditureFinancialDocumentTypeCodeAK



purchaseOrderNumberAL



requisitionNumberAM



expenditureFinancialDocumentPostedDateAN



postingPeriodCodeAO



amountAPYes


approvalMethodAQ



FiscalYearAR



...