Journal Entry Metadata

GET {{base_url}}/metadata/JEEntry

Use this endpoint to retrieve the Journal Entry 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

The type of content supported by the API endpoint. | | Authorization | string | | Required.

The type of authorization supported by the API endpoint. |

RESPONSES

status: OK

{"jeControl":{"Keys":"Batch","TableName":"jeControl","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Recurring","FieldType":"Checkbox","Caption":"Recurring","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"End Date","DefaultValue":"2007-12-31T00:00:00.000","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"DefaultCurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"Total","FieldType":"Numeric","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreditsTotal","FieldType":"Numeric","Caption":"Credits","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SumDebitsTotal","FieldType":"Numeric","Caption":"File Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SumCreditsTotal","FieldType":"Numeric","Caption":"Control Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DiffDebitsTotal","FieldType":"Numeric","Caption":"Difference","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DiffCreditsTotal","FieldType":"Numeric","Caption":"DiffCreditsTotal","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AllowTaxEntries","FieldType":"Checkbox","Caption":"Allow Tax Entries","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Selected","FieldType":"String","Caption":"Selected","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Posted","FieldType":"String","Caption":"Posted","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Creator","FieldType":"String","Caption":"Creator","DefaultValue":"ADMIN","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Period","FieldType":"Numeric","Caption":"Period","DefaultValue":"200712","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Company","FieldType":"Company","Caption":"Company","DefaultValue":"[CURRENTCOMPANY]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"RecurSchedule","FieldType":"Checkbox","Caption":"Manage Recurring","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurClearAmounts","FieldType":"Checkbox","Caption":"Clear Amounts After Posting","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurStartDate","FieldType":"Date","Caption":"First Recurrence","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurFrequency","FieldType":"Dropdown","Caption":"Frequency","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"Codes":{"M":"Monthly","Y":"Yearly","C":"Custom"},"LimitToList":true},{"FieldName":"RecurType","FieldType":"Dropdown","Caption":"RecurType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"Codes":{"N":"Number of Recurrences","D":"Expiration Date"},"LimitToList":true},{"FieldName":"RecurTimes","FieldType":"Numeric","Caption":"RecurTimes","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurExpirationDate","FieldType":"Date","Caption":"RecurExpirationDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurAutoPost","FieldType":"Checkbox","Caption":"Schedule Posting","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurProcessQueue","FieldType":"Dropdown","Caption":"Queue","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"FW_CFGProcessQueue, SE","LimitToList":true},{"FieldName":"RecurTimesUsed","FieldType":"Numeric","Caption":"Times Used","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecurLastPostDate","FieldType":"Date","Caption":"Last Processed","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Reverse","FieldType":"Checkbox","Caption":"Reverse On","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReverseDate","FieldType":"Date","Caption":"ReverseDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReverseAutoPost","FieldType":"Checkbox","Caption":"Schedule Posting","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReverseProcessQueue","FieldType":"Dropdown","Caption":"Queue","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"FW_CFGProcessQueue, SE","LimitToList":true},{"FieldName":"RecurAlert","FieldType":"Checkbox","Caption":"Send Alert to Submitter","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReverseAlert","FieldType":"Checkbox","Caption":"Send Alert to Submitter","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProcessID","FieldType":"String","Caption":"ProcessID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"jeControl"},"jeMasterKey":{"Keys":"Batch,RefNo","TableName":"jeMasterKey","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RefNo","FieldType":"Uppercase","Caption":"RefNo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":7},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TransDate","FieldType":"String","Caption":"TransDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StatusDesc","FieldType":"String","Caption":"StatusDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true}],"Caption":"jeMasterKey"},"jeMaster":{"Keys":"Batch,RefNo","TableName":"jeMaster","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"RefNo","FieldType":"Uppercase","Caption":"Reference Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":7},{"FieldName":"TransDate","FieldType":"Date","Caption":"Transaction Date","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":40},{"FieldName":"AllowAssetEntries","FieldType":"Checkbox","Caption":"Allow Equipment Entries","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"3","Hidden":false,"Required":false,"Updateable":true,"Codes":{"1":"Accrual","2":"Cash","3":"Accrual and Cash"},"LimitToList":true},{"FieldName":"UpdateBilled","FieldType":"Checkbox","Caption":"Update Project billing amount when adjusting revenue","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Posted","FieldType":"String","Caption":"Posted","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"CurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"CurrencyExchangeOverrideMethod","FieldType":"String","Caption":"CurrencyExchangeOverrideMethod","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CurrencyExchangeOverrideDate","FieldType":"Date","Caption":"CurrencyExchangeOverrideDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CurrencyExchangeOverrideRate","FieldType":"Numeric","Caption":"CurrencyExchangeOverrideRate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":10},{"FieldName":"Status","FieldType":"String","Caption":"Status","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StatusDescription","FieldType":"String","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AuthorizedByName","FieldType":"String","Caption":"Approved By","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AuthorizedBy","FieldType":"String","Caption":"AuthorizedBy","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RejectReason","FieldType":"String","Caption":"Reject Reason","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":500},{"FieldName":"ModUser","FieldType":"String","Caption":"ModUser","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUserEmployee","FieldType":"String","Caption":"ModUserEmployee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"ModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Diary","FieldType":"Dropdown","Caption":"Diary","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGDiaryAutoNum LEFT JOIN CFGDiary ON CFGDiaryAutoNum.Code = CFGDiary.Code LEFT JOIN CFGDatesStatus ON CFGDiaryAutoNum.Period = CFGDatesStatus.Period And CFGDiaryAutoNum.Company = CFGDatesStatus.Company LEFT JOIN (SELECT '0/'+CONVERT(varchar,Years) AS Pd, Years * 100 AS Period FROM (SELECT Distinct Period/100 AS Years FROM CFGDatesStatus WHERE Closed = 'N' and CFGDatesStatus.Company = /*N*/'PR') x) _OpenYear ON CFGDiaryAutoNum.Period = _OpenYear.Period","LimitToList":true},{"FieldName":"DiaryNo","FieldType":"Numeric","Caption":"Diary Number","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false}],"Caption":"jeMaster"},"jeDetail":{"Keys":"Batch,RefNo,PKey","TableName":"jeDetail","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"RefNo","FieldType":"String","Caption":"RefNo","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"EquipmentID","FieldType":"String","Caption":"\u003cbr /\u003eEquipment","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EquipmentDesc","FieldType":"Equipment","Caption":"\u003cbr /\u003eEquipment","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"Description","FieldType":"String","Caption":"\u003cbr/\u003eDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"\u003cbr /\u003eProject","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS1Name","FieldType":"String","Caption":"\u003cbr /\u003eProject Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClientName","FieldType":"String","Caption":"\u003cbr /\u003eClient Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBS2Level","FieldType":"String","Caption":"WBS2Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ChargeType","FieldType":"String","Caption":"ChargeType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"\u003cbr /\u003ePhase","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS2Name","FieldType":"String","Caption":"\u003cbr /\u003ePhase Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBS3Level","FieldType":"String","Caption":"WBS3Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"\u003cbr /\u003eTask","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3Name","FieldType":"String","Caption":"\u003cbr /\u003eTask Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FunctionalCurrencyCode","FieldType":"String","Caption":"FunctionalCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Org","FieldType":"String","Caption":"Org","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Account","FieldType":"Account","Caption":"\u003cbr /\u003eAccount","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":6},{"FieldName":"AccountName","FieldType":"String","Caption":"\u003cbr /\u003eAccount Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AccountCurrencyCode","FieldType":"String","Caption":"AccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"GlobalAccount","FieldType":"String","Caption":"GlobalAccount","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AccountType","FieldType":"Numeric","Caption":"AccountType","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DebitAmount","FieldType":"Currency","Caption":"\u003cbr /\u003eDebit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreditAmount","FieldType":"Currency","Caption":"\u003cbr /\u003eCredit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TotalTaxDebit","FieldType":"Currency","Caption":"Total\u003cbr /\u003eTax Debit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalTaxCredit","FieldType":"Currency","Caption":"Total\u003cbr /\u003eTax Credit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TaxType","FieldType":"Dropdown","Caption":"Tax\u003cbr /\u003eType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"I":"Input (Purchase)","O":"Output (Sale)"},"LimitToList":true},{"FieldName":"CurrencyExchangeOverrideRate","FieldType":"Numeric","Caption":"Exchange\u003cbr /\u003eOverride Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":10},{"FieldName":"SuppressBill","FieldType":"Checkbox","Caption":"Suppress\u003cbr /\u003eBill","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"LinkCompany","FieldType":"Company","Caption":"Due To/From\u003cbr /\u003eCompany","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":14},{"FieldName":"DebitAmountFunctionalCurrency","FieldType":"Currency","Caption":"DebitAmountFunctionalCurrency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreditAmountFunctionalCurrency","FieldType":"Currency","Caption":"CreditAmountFunctionalCurrency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DebitAmountProjectCurrency","FieldType":"Currency","Caption":"DebitAmountProjectCurrency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreditAmountProjectCurrency","FieldType":"Currency","Caption":"CreditAmountProjectCurrency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Document","FieldType":"String","Caption":"Document","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DocumentToolTipColumn","FieldType":"String","Caption":"DocumentToolTipColumn","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"jeDetail"},"jeDetailTax":{"Keys":"Batch,RefNo,PKey,TaxCode","TableName":"jeDetailTax","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"RefNo","FieldType":"String","Caption":"RefNo","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"TaxCode","FieldType":"String","Caption":"\u003cbr /\u003eTax Code","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TaxDebitAmount","FieldType":"Currency","Caption":"\u003cbr /\u003eDebit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TaxCreditAmount","FieldType":"Currency","Caption":"\u003cbr /\u003eCredit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CompoundOnTaxCode","FieldType":"String","Caption":"CompoundOnTaxCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Rate","FieldType":"Numeric","Caption":"Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LowRate","FieldType":"Numeric","Caption":"LowRate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HighRate","FieldType":"Numeric","Caption":"HighRate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DebitAccountCurrencyCode","FieldType":"String","Caption":"DebitAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreditAccountCurrencyCode","FieldType":"String","Caption":"CreditAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TaxType","FieldType":"String","Caption":"TaxType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EffectiveRate","FieldType":"Numeric","Caption":"EffectiveRate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CompoundOnTaxCodeFromSetup","FieldType":"String","Caption":"CompoundOnTaxCodeFromSetup","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"jeDetailTax"},"jeControlRecurFrequency":{"Keys":"Batch,Seq","TableName":"jeControlRecurFrequency","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Date","FieldType":"Date","Caption":"Date","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Processed","FieldType":"Checkbox","Caption":"Processed","DefaultValue":"N","Hidden":true,"Required":false,"Updateable":true}],"Caption":"jeControlRecurFrequency"},"FW_CFGProcessQueue,SE":{"Keys":"QueueID","TableName":"FW_CFGProcessQueue,SE","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"QueueID","FieldType":"String","Caption":"QueueID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"QueueName","FieldType":"String","Caption":"QueueName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"QueueStatus","FieldType":"String","Caption":"QueueStatus","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true}],"Caption":"FW_CFGProcessQueue,SE"},"JEDOCUMENTS":{"Keys":"Batch,MasterPKey,FileID","TableName":"JEDOCUMENTS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"AssociateNew","FieldType":"Checkbox","Caption":"AssociateNew","DefaultValue":"N","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"FileName","FieldType":"String","Caption":"FileName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FileNameSaved","FieldType":"String","Caption":"FileNameSaved","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FileDescription","FieldType":"String","Caption":"FileDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":500},{"FieldName":"FileDescriptionSaved","FieldType":"String","Caption":"FileDescriptionSaved","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"JEDOCUMENTS"},"JEDOCUMENTSDETAIL":{"Keys":"Batch,MasterPKey,FileID,DetailPKey","TableName":"JEDOCUMENTSDETAIL","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"DetailPKey","FieldType":"String","Caption":"DetailPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true}],"Caption":"JEDOCUMENTSDETAIL"}}