Difference between revisions of "ADCK AD ImpFormat"

Revision as of 03:27, 29 July 2007

• Xml file is stored in:

_Project-ID-Xxxx/xml/data/AD_ImpFormat.xml

• How to import AD_ImpFormat records into AD:

From command line execute: "build-ID-001.[bat|sh] imp_AD_ImpFormat"

	<AD_ImpFormat>
		<AD_Client_Value>GardenWorld</AD_Client_Value>
		<AD_Org_Value>HQ</AD_Org_Value>
		<IsActive>Y</IsActive>
		<Name>Invoice LineTax FCS</Name>
		<Description>Example Order Format</Description>
		<AD_Table_TableName>I_Order</AD_Table_Name>
		<FormatType>C</FormatType> <!-- C=Comma Separated; F=Fixed Position; T=Tab Separated; X=XML -->
		<AD_ImpFormat_Row>
			<IsActive>Y</IsActive>
			<SeqNo>0</SeqNo> <!-- integer -->
			<Name>Tax</Name>
			<Callout>Field</Callout>
			<ConstantValue>Y</ConstantValue>
			<DataFormat></DataFormat>
			<DataType>S</DataType> <!-- C=Constant; D=Date; N=Number; S=String -->
			<DecimalPoint>.</DecimalPoint>
			<DivideBy100>N</DivideBy100> <!-- Y/N -->
			<StartNo>0</StartNo> <!-- integer -->
			<EndNo>0</EndNo> <!-- integer -->
			<Script></Script>
			<AD_Column_ColumnName>Tax</AD_Column_ColumnName>
		</AD_ImpFormat_Row>
	</AD_ImpFormat>