Retrieve AP Invoice Approvals Metadata
GET {{base_url}}/metadata/APInvoiceApprovals
Use this endpoint to retrieve the AP Invoice Approvals metadata.
The metadata describes the fields in each table of the database for the record and describes whether or not the table is a custom table and whether or not it has a grid ID. Each field describes whether or not the field is required, the data type, the default value, whether or not it is updateable, and other useful minimums, limits, and maximum details.
For more information, see Metadata Reference.
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string | Required. |
The type of content supported by the API endpoint. |
| Authorization | string | | Required.
The type of authorization supported by the API endpoint. |
RESPONSES
status: OK
{"APApprovalMaster":{"Keys":"MasterPKey","TableName":"APApprovalMaster","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"[GUID]","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"ApprovalID","FieldType":"String","Caption":"Approval ID","DefaultValue":"","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":false,"BaseUpdateable":false,"Searchable":true,"MaxLength":12,"Secured":false},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"N","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":true,"Secured":false,"LimitToList":true},{"FieldName":"StatusDesc","FieldType":"String","Caption":"StatusDesc","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Company","FieldType":"Company","Caption":"Company","DefaultValue":"[CURRENTCOMPANY]","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":14,"Secured":false},{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Consultant","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":10,"Secured":false,"SearchField_Like":"VendorName"},{"FieldName":"VendorName","FieldType":"String","Caption":"VendorName","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"VendorTerms","FieldType":"String","Caption":"VendorTerms","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"VendorTypeLiab","FieldType":"String","Caption":"VendorTypeLiab","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"VendorTaxCode","FieldType":"String","Caption":"VendorTaxCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"VendorMatchMethod","FieldType":"String","Caption":"VendorMatchMethod","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Invoice","FieldType":"String","Caption":"Invoice","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":20,"Secured":false},{"FieldName":"InvoiceDate","FieldType":"Date","Caption":"Invoice Date","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"Secured":false},{"FieldName":"Address","FieldType":"Dropdown","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":20,"Secured":false,"LimitToList":true},{"FieldName":"LiabCode","FieldType":"Dropdown","Caption":"AP Liability","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":10,"Secured":false,"LimitToList":true},{"FieldName":"PayTerms","FieldType":"Dropdown","Caption":"Payment","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":7,"Secured":false,"LimitToList":true},{"FieldName":"PayDate","FieldType":"Date","Caption":"Pay Date","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"Secured":false},{"FieldName":"OrigPODetailPKey","FieldType":"String","Caption":"OrigPODetailPKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"PONumberMaster","FieldType":"String","Caption":"PONumberMaster","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"InvoiceAmount","FieldType":"Currency","Caption":"Invoice Amount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"CurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":3,"Secured":false,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"RouteType","FieldType":"Dropdown","Caption":"Route To","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":6,"Secured":false,"Codes":{"EM":"Employee","ORG":"Organization"},"LimitToList":true},{"FieldName":"RouteToEmployee","FieldType":"Employee","Caption":"Route To Employee","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":5,"Secured":false,"SearchField_Like":"RouteToEmployeeName"},{"FieldName":"RouteToEmployeeName","FieldType":"Employee","Caption":"RouteToEmployeeName","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"MaxLength":5,"Secured":false},{"FieldName":"RouteToEMEmail","FieldType":"String","Caption":"RouteToEMEmail","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"RouteToOrgName","FieldType":"Org","Caption":"RouteToOrgName","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"MaxLength":8,"Secured":false},{"FieldName":"RouteToOrg","FieldType":"Org","Caption":"Route To Organization","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":8,"Secured":false,"SearchField_Like":"RouteToOrgName"},{"FieldName":"SubmittedBy","FieldType":"String","Caption":"SubmittedBy","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"SubmittedDate","FieldType":"Datetime","Caption":"SubmittedDate","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"CreateUser","FieldType":"String","Caption":"CreateUser","DefaultValue":"2D424230ADA044419FCD78E4E8F3BD61","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"CreateDate","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"ModUser","FieldType":"String","Caption":"ModUser","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"ModDate","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"DefaultExpenseCode","FieldType":"String","Caption":"DefaultExpenseCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"RegAccount","FieldType":"String","Caption":"RegAccount","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"RegAccountName","FieldType":"String","Caption":"RegAccountName","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"RegAccountCurrencyCode","FieldType":"String","Caption":"RegAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"RegAccountGlobal","FieldType":"String","Caption":"RegAccountGlobal","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"RegAccountType","FieldType":"String","Caption":"RegAccountType","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"OHAccount","FieldType":"String","Caption":"OHAccount","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"OHAccountName","FieldType":"String","Caption":"OHAccountName","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"OHAccountCurrencyCode","FieldType":"String","Caption":"OHAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"OHAccountGlobal","FieldType":"String","Caption":"OHAccountGlobal","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"OHAccountType","FieldType":"String","Caption":"OHAccountType","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"opBatch","FieldType":"String","Caption":"opBatch","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"opVoucherDate","FieldType":"Date","Caption":"opVoucherDate","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"Option","FieldType":"String","Caption":"Option","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"opEndDate","FieldType":"Date","Caption":"opEndDate","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"opBank","FieldType":"String","Caption":"opBank","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"opNextVoucherNumber","FieldType":"String","Caption":"opNextVoucherNumber","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"opDiary","FieldType":"String","Caption":"opDiary","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"opPOPeriod","FieldType":"Numeric","Caption":"opPOPeriod","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"opPOPostSeq","FieldType":"Numeric","Caption":"opPOPostSeq","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"FinalApprove","FieldType":"String","Caption":"FinalApprove","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ApplicationID","FieldType":"String","Caption":"ApplicationID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ApplicationKey","FieldType":"String","Caption":"ApplicationKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ApprovalActionsAllowed","FieldType":"String","Caption":"ApprovalActionsAllowed","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ApprovalStatus","FieldType":"String","Caption":"State","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"AssignUSR_ID","FieldType":"Employee","Caption":"AssignUSR_ID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"MaxLength":5,"Secured":false},{"FieldName":"AssignItem_UID","FieldType":"String","Caption":"AssignItem_UID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"CompletionStatusCode","FieldType":"String","Caption":"CompletionStatusCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"IsClosed","FieldType":"String","Caption":"IsClosed","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"IsSuspended","FieldType":"String","Caption":"IsSuspended","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"IsUpdated","FieldType":"String","Caption":"IsUpdated","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Item_UID","FieldType":"String","Caption":"Item_UID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ItemModDate","FieldType":"Datetime","Caption":"ItemModDate","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ItemParent_UID","FieldType":"String","Caption":"ItemParent_UID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ItemType_UID","FieldType":"String","Caption":"ItemType_UID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"MyActionRequired","FieldType":"String","Caption":"My Action Required","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":true,"Secured":false},{"FieldName":"NextStepAssignmentSelection","FieldType":"String","Caption":"NextStepAssignmentSelection","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Reject","FieldType":"String","Caption":"Reject","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ReviewAction","FieldType":"String","Caption":"ReviewAction","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WorkflowFlag","FieldType":"String","Caption":"WorkflowFlag","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WorkflowStep","FieldType":"Numeric","Caption":"Step","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":true,"Secured":false},{"FieldName":"OrgDoNotUse","FieldType":"String","Caption":"OrgDoNotUse","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"StatusCode","FieldType":"Dropdown","Caption":"State","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":true,"Secured":false,"LimitToList":true}],"Caption":"AP Invoice Approval"},"APApprovalDocuments":{"Keys":"MasterPKey,FileID","TableName":"APApprovalDocuments","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"FileName","FieldType":"String","Caption":"File Name","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":true,"Secured":false},{"FieldName":"FileDescription","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"Secured":false}],"Caption":"AP Invoice"},"APApprovalWBS":{"Keys":"MasterPKey,PKey","TableName":"APApprovalWBS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":80,"Secured":false},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Name","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":9,"Secured":false},{"FieldName":"WBS1Name","FieldType":"String","Caption":"WBS1Name","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WBS1ID","FieldType":"String","Caption":"Project","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WBS2Level","FieldType":"String","Caption":"WBS2Level","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ChargeType","FieldType":"String","Caption":"ChargeType","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"Phase Name","DefaultValue":" ","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":3,"Secured":false},{"FieldName":"WBS2Name","FieldType":"String","Caption":"WBS2Name","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WBS2ID","FieldType":"String","Caption":"Phase","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WBS3Level","FieldType":"String","Caption":"WBS3Level","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"Task Name","DefaultValue":" ","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":3,"Secured":false},{"FieldName":"WBS3Name","FieldType":"String","Caption":"WBS3Name","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"WBS3ID","FieldType":"String","Caption":"Task","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Org","FieldType":"String","Caption":"Org","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"BillByDefaultConsultants","FieldType":"String","Caption":"BillByDefaultConsultants","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"BillByDefaultOtherExp","FieldType":"String","Caption":"BillByDefaultOtherExp","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"BillByDefaultORTable","FieldType":"String","Caption":"BillByDefaultORTable","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ExpenseCode","FieldType":"Dropdown","Caption":"Expense Category","DefaultValue":"","Hidden":true,"BaseHidden":true,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":10,"Secured":false,"LimitToList":true},{"FieldName":"ExpenseCodeType","FieldType":"String","Caption":"ExpenseCodeType","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"AccountEditable","FieldType":"String","Caption":"AccountEditable","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Account","FieldType":"Account","Caption":"Account","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":6,"Secured":false},{"FieldName":"AccountName","FieldType":"String","Caption":"Account Name","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"AccountType","FieldType":"Numeric","Caption":"AccountType","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"AccountCurrencyCode","FieldType":"String","Caption":"AccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"GlobalAccount","FieldType":"String","Caption":"GlobalAccount","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"NetAmount","FieldType":"Currency","Caption":"Net Amount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"TotalTax","FieldType":"Currency","Caption":"Total Tax Amount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"Amount","FieldType":"Currency","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"FunctionalCurrencyCode","FieldType":"String","Caption":"FunctionalCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"DefaultsSet","FieldType":"String","Caption":"DefaultsSet","DefaultValue":"","Hidden":true,"BaseHidden":true,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ClientName","FieldType":"String","Caption":"Client Name","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false}],"Caption":"Project"},"APApprovalWBSTax":{"Keys":"MasterPKey,PKey,TaxCode","TableName":"APApprovalWBSTax","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"TaxCode","FieldType":"String","Caption":"TaxCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"TaxAmount","FieldType":"Currency","Caption":"TaxAmount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"CompoundOnTaxCode","FieldType":"String","Caption":"CompoundOnTaxCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"Rate","FieldType":"Numeric","Caption":"Rate","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"LowRate","FieldType":"Numeric","Caption":"LowRate","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"HighRate","FieldType":"Numeric","Caption":"HighRate","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"AccountCurrencyCode","FieldType":"String","Caption":"AccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"EffectiveRate","FieldType":"Numeric","Caption":"EffectiveRate","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"CompoundOnTaxCodeFromSetup","FieldType":"String","Caption":"CompoundOnTaxCodeFromSetup","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ReverseCharge","FieldType":"String","Caption":"ReverseCharge","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false}],"Caption":"APApprovalWBSTax"},"APApprovalNotes":{"Keys":"MasterPKey,PKey","TableName":"APApprovalNotes","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"Comments","FieldType":"String","Caption":"Comment","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"Secured":false},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"VPCO1","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":true,"MaxLength":5,"Secured":false},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"EMEmail","FieldType":"String","Caption":"EMEmail","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"EmployeeName","FieldType":"String","Caption":"EmployeeName","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false}],"Caption":"Note"},"APApprovalPO":{"Keys":"MasterPKey,PODetailPKey","TableName":"APApprovalPO","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"PODetailPKey","FieldType":"String","Caption":"PODetailPKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"PONumber","FieldType":"String","Caption":"PONumber","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"ReleaseNumber","FieldType":"String","Caption":"ReleaseNumber","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"CONumber","FieldType":"Numeric","Caption":"CONumber","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Type","FieldType":"String","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false},{"FieldName":"Amount","FieldType":"Currency","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"ReceivedAmount","FieldType":"Currency","Caption":"ReceivedAmount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"VoucheredAmount","FieldType":"Currency","Caption":"VoucheredAmount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"OldVoucheredAmount","FieldType":"Currency","Caption":"OldVoucheredAmount","DefaultValue":"0","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false,"CurrencyCodeColumn":null},{"FieldName":"Matched","FieldType":"String","Caption":"Matched","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false}],"Caption":"APApprovalPO"},"ApprovalItem":{"Keys":"Item_UID","TableName":"ApprovalItem","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Item_UID","FieldType":"String","Caption":"Item_UID","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"IsUpdated","FieldType":"String","Caption":"IsUpdated","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":false,"BaseRequired":false,"Updateable":false,"BaseUpdateable":false,"Searchable":false,"Secured":false}],"Caption":"ApprovalItem"},"FW_Files":{"Keys":"FileID","TableName":"FW_Files","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false},{"FieldName":"FileDescription","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"BaseRequired":true,"Updateable":true,"BaseUpdateable":true,"Searchable":false,"Secured":false}],"Caption":"FW_Files"}}