AP Voucher Metadata

GET {{base_url}}/Metadata/APEntry

Use this endpoint to retrieve the AP Voucher 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

{"apControl":{"Keys":"Batch","CustomTable":false,"TableName":"apControl","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Description","FieldType":"String","Caption":"File Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":40},{"FieldName":"Recurring","FieldType":"Checkbox","Caption":"Recurring","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"EndDate","FieldType":"Date","Caption":"End Date","DefaultValue":"2017-12-31T00:00:00.000","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"DefaultCurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":3},{"FieldName":"Total","FieldType":"Numeric","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"SumTotal","FieldType":"Numeric","Caption":"File Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"DiffTotal","FieldType":"Numeric","Caption":"Difference","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"DefaultLiab","FieldType":"Dropdown","Caption":"Default Liability","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"CodeTable":"CFGAPLiability Inner Join CA On CFGAPLiability.Account = CA.Account","LimitToList":true},{"FieldName":"DefaultLiabDescription","FieldType":"String","Caption":"Default Liability","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"DefaultBank","FieldType":"Dropdown","Caption":"Default Bank","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"CodeTable":"CFGBanks Inner Join CA On CFGBanks.Account = CA.Account","LimitToList":true},{"FieldName":"DefaultBankDescription","FieldType":"String","Caption":"Default Bank","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"DefaultDate","FieldType":"Date","Caption":"Default Voucher Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Selected","FieldType":"String","Caption":"Selected","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Posted","FieldType":"String","Caption":"Posted","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Creator","FieldType":"String","Caption":"Creator","DefaultValue":"ADMIN","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Period","FieldType":"Numeric","Caption":"Period","DefaultValue":"201305","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Company","FieldType":"Company","Caption":"Company","DefaultValue":"[CURRENTCOMPANY]","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":14},{"FieldName":"LiabAccountCurrencyCode","FieldType":"String","Caption":"LiabAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"BankAccountCurrencyCode","FieldType":"String","Caption":"BankAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false}],"Caption":"apControl"},"apMasterKey":{"Keys":"Batch,MasterPKey","CustomTable":false,"TableName":"apMasterKey","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":11},{"FieldName":"Invoice","FieldType":"String","Caption":"Invoice","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"InvoiceDate","FieldType":"Date","Caption":"InvoiceDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"StatusDesc","FieldType":"String","Caption":"StatusDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false}],"Caption":"apMasterKey"},"apMaster":{"Keys":"Batch,MasterPKey","CustomTable":false,"TableName":"apMaster","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"AllowAssetEntries","FieldType":"Checkbox","Caption":"Allow Equipment Entries","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"VendorXx","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":11},{"FieldName":"VendorName","FieldType":"String","Caption":"VendorXx","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"VendorTerms","FieldType":"String","Caption":"VendorTerms","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"VendorTaxCode","FieldType":"String","Caption":"VendorTaxCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"RegAccount","FieldType":"Account","Caption":"RegAccount","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false,"MaxLength":9},{"FieldName":"OHAccount","FieldType":"Account","Caption":"OHAccount","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false,"MaxLength":9},{"FieldName":"DefaultExpenseCode","FieldType":"String","Caption":"DefaultExpenseCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"RegAccountName","FieldType":"String","Caption":"RegAccountName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"OHAccountName","FieldType":"String","Caption":"OHAccountName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"RegAccountCurrencyCode","FieldType":"String","Caption":"RegAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"OHAccountCurrencyCode","FieldType":"String","Caption":"OHAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"RegAccountGlobal","FieldType":"String","Caption":"RegAccountGlobal","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"OHAccountGlobal","FieldType":"String","Caption":"OHAccountGlobal","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"RegAccountType","FieldType":"String","Caption":"RegAccountType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"OHAccountType","FieldType":"String","Caption":"OHAccountType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"LiabAccountCurrencyCode","FieldType":"String","Caption":"LiabAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"PaymentCurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":3},{"FieldName":"InvoiceDate","FieldType":"Date","Caption":"Invoice Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Invoice","FieldType":"String","Caption":"Invoice","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":20},{"FieldName":"TransDate","FieldType":"Date","Caption":"Voucher Date","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Voucher","FieldType":"Uppercase","Caption":"Voucher","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":11},{"FieldName":"PayTerms","FieldType":"String","Caption":"Payment Terms","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":7},{"FieldName":"PayDate","FieldType":"Date","Caption":"Payment Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"LiabCode","FieldType":"String","Caption":"AP Liability","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":10},{"FieldName":"BankCode","FieldType":"String","Caption":"Bank","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":10},{"FieldName":"Address","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":20},{"FieldName":"DuplicateVoucher","FieldType":"String","Caption":"DuplicateVoucher","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"Posted","FieldType":"String","Caption":"Posted","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"CurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":3},{"FieldName":"CurrencyExchangeOverrideMethod","FieldType":"String","Caption":"CurrencyExchangeOverrideMethod","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"CurrencyExchangeOverrideDate","FieldType":"Date","Caption":"CurrencyExchangeOverrideDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"CurrencyExchangeOverrideRate","FieldType":"Numeric","Caption":"CurrencyExchangeOverrideRate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"Decimals":10},{"FieldName":"PaymentExchangeOverrideMethod","FieldType":"String","Caption":"PaymentExchangeOverrideMethod","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"PaymentExchangeOverrideDate","FieldType":"Date","Caption":"PaymentExchangeOverrideDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"PaymentExchangeOverrideRate","FieldType":"Numeric","Caption":"PaymentExchangeOverrideRate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"Decimals":10},{"FieldName":"Status","FieldType":"String","Caption":"Status","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"StatusDescription","FieldType":"String","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"AuthorizedByName","FieldType":"String","Caption":"Approved By","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"AuthorizedBy","FieldType":"String","Caption":"AuthorizedBy","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"RejectReason","FieldType":"String","Caption":"Reject Reason","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":500},{"FieldName":"ModUser","FieldType":"String","Caption":"ModUser","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"ModUserEmployee","FieldType":"String","Caption":"ModUserEmployee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"ModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"BankAccountCurrencyCode","FieldType":"String","Caption":"BankAccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"Diary","FieldType":"Dropdown","Caption":"Diary","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"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*/'A0') x) _OpenYear ON CFGDiaryAutoNum.Period = _OpenYear.Period","LimitToList":true},{"FieldName":"DiaryNo","FieldType":"Numeric","Caption":"Diary Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false}],"Caption":"apMaster"},"apDetail":{"Keys":"Batch,MasterPKey,PKey","CustomTable":false,"TableName":"apDetail","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"CreateAsset","FieldType":"String","Caption":"Create\u003cbr /\u003eAsset","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"AssetType","FieldType":"String","Caption":"Asset\u003cbr /\u003eType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Item","FieldType":"String","Caption":"\u003cbr /\u003eItem Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":30},{"FieldName":"EquipmentID","FieldType":"String","Caption":"\u003cbr /\u003eEquipment ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"EquipmentDesc","FieldType":"String","Caption":"Associate To\u003cbr /\u003eExisting Asset","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"Description","FieldType":"String","Caption":"\u003cbr /\u003eDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":80},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"\u003cbr /\u003eProjectXx","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":12},{"FieldName":"WBS1Name","FieldType":"String","Caption":"\u003cbr /\u003eProjectXx Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"ClientName","FieldType":"String","Caption":"\u003cbr /\u003eClientXx Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"WBS2Level","FieldType":"String","Caption":"WBS2Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"ChargeType","FieldType":"String","Caption":"ChargeType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"\u003cbr /\u003ePhaseXx","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":4},{"FieldName":"WBS2Name","FieldType":"String","Caption":"\u003cbr /\u003ePhaseXx Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"WBS3Level","FieldType":"String","Caption":"WBS3Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"\u003cbr /\u003eTaskXx","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":4},{"FieldName":"WBS3Name","FieldType":"String","Caption":"\u003cbr /\u003eTaskXx Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"FunctionalCurrencyCode","FieldType":"String","Caption":"FunctionalCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"Org","FieldType":"String","Caption":"Org","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"ExpenseCode","FieldType":"String","Caption":"Expense\u003cbr /\u003eCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"ExpenseCodeType","FieldType":"String","Caption":"ExpenseCodeType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"AccountEditable","FieldType":"String","Caption":"AccountEditable","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"BillByDefaultConsultants","FieldType":"String","Caption":"BillByDefaultConsultants","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"BillByDefaultOtherExp","FieldType":"String","Caption":"BillByDefaultOtherExp","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"BillByDefaultORTable","FieldType":"String","Caption":"BillByDefaultORTable","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"Account","FieldType":"Account","Caption":"\u003cbr /\u003eAccountZ","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false,"MaxLength":9},{"FieldName":"AccountName","FieldType":"String","Caption":"\u003cbr /\u003eAccountZ Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"AccountCurrencyCode","FieldType":"String","Caption":"AccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"GlobalAccount","FieldType":"String","Caption":"GlobalAccount","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"AccountType","FieldType":"Numeric","Caption":"AccountType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"NetAmount","FieldType":"Currency","Caption":"Net\u003cbr /\u003eAmount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"TotalTax","FieldType":"Currency","Caption":"Total Tax\u003cbr /\u003eAmount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"OriginatingVendor","FieldType":"Vendor","Caption":"Originating\u003cbr /\u003eVendorXx","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":11},{"FieldName":"Amount","FieldType":"Currency","Caption":"\u003cbr /\u003eAmount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"CurrencyExchangeOverrideRate","FieldType":"Numeric","Caption":"Exchange\u003cbr /\u003eOverride Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"Decimals":10},{"FieldName":"PaymentAmount","FieldType":"Currency","Caption":"Payment\u003cbr /\u003eAmount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"PaymentExchangeInfo","FieldType":"XML","Caption":"PaymentExchangeInfo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"SuppressBill","FieldType":"String","Caption":"Suppress\u003cbr /\u003eBill","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"PONumber","FieldType":"String","Caption":"Purchase\u003cbr /\u003eOrder","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Document","FieldType":"String","Caption":"Document","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"DocumentToolTipColumn","FieldType":"String","Caption":"DocumentToolTipColumn","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"OriginatingVendorName","FieldType":"String","Caption":"OriginatingVendorName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"DefaultsSet","FieldType":"String","Caption":"DefaultsSet","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"TaxToolTipColumn","FieldType":"String","Caption":"TaxToolTipColumn","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false}],"Caption":"apDetail"},"apControlDefaultTaxCodes":{"Keys":"Batch,TaxCode","CustomTable":false,"TableName":"apControlDefaultTaxCodes","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"TaxCode","FieldType":"String","Caption":"Tax Code","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false}],"Caption":"apControlDefaultTaxCodes"},"apDetailTax":{"Keys":"Batch,MasterPKey,PKey,TaxCode","CustomTable":false,"TableName":"apDetailTax","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"TaxCode","FieldType":"String","Caption":"Tax Code","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"TaxAmount","FieldType":"Currency","Caption":"Tax Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"CompoundOnTaxCode","FieldType":"String","Caption":"CompoundOnTaxCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false},{"FieldName":"Rate","FieldType":"Numeric","Caption":"Rate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"LowRate","FieldType":"Numeric","Caption":"LowRate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"HighRate","FieldType":"Numeric","Caption":"HighRate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"AccountCurrencyCode","FieldType":"String","Caption":"AccountCurrencyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"EffectiveRate","FieldType":"Numeric","Caption":"EffectiveRate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"CompoundOnTaxCodeFromSetup","FieldType":"String","Caption":"CompoundOnTaxCodeFromSetup","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"ReverseCharge","FieldType":"String","Caption":"ReverseCharge","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false}],"Caption":"apDetailTax"},"APDOCUMENTS":{"Keys":"Batch,MasterPKey,FileID","CustomTable":false,"TableName":"APDOCUMENTS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"AssociateNew","FieldType":"Checkbox","Caption":"AssociateNew","DefaultValue":"N","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"FileName","FieldType":"String","Caption":"FileName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"FileNameSaved","FieldType":"String","Caption":"FileNameSaved","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false},{"FieldName":"FileDescription","FieldType":"String","Caption":"FileDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":false,"MaxLength":500},{"FieldName":"FileDescriptionSaved","FieldType":"String","Caption":"FileDescriptionSaved","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":false}],"Caption":"APDOCUMENTS"},"APDOCUMENTSDETAIL":{"Keys":"Batch,MasterPKey,FileID,DetailPKey","CustomTable":false,"TableName":"APDOCUMENTSDETAIL","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"MasterPKey","FieldType":"String","Caption":"MasterPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false},{"FieldName":"DetailPKey","FieldType":"String","Caption":"DetailPKey","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":false}],"Caption":"APDOCUMENTSDETAIL"}}