---------------------------------------------------------------------------------- Description of Input File Template ---------------------------------------------------------------------------------- File Type : ExtSuppInv Supplier Invoice File File Template : STDSIN1 Standard Supplier Invoice File H,I,P,T,N ---------------------------------------------------------------------------------- Record Type : H Supplier Invoice Head ---------------------------------------------------------------------------------- Column Desc Type Column No ---------------------------------------------------------------------------------- Line Type STRING 1 Identity STRING 2 Invoice No STRING 3 Transaction Date DATE 4 Invoice Type STRING 5 Invoice Date DATE 6 Arrival Date DATE 7 Due Date DATE 8 Payment Term Id STRING 9 Currency STRING 10 Curr Rate NUMBER 11 Auth Id STRING 12 Voucher Type STRING 13 Voucher No NUMBER 14 Notes STRING 15 Plan Payment Date DATE 16 Div Factor NUMBER 17 Prelim Code STRING 18 National Bank Code STRING 19 Creators Reference STRING 20 PO Reference STRING 21 Series Reference STRING 22 Number Reference STRING 23 Discount Date 1 DATE 24 Discount Perc 1 NUMBER 25 Discount Date 2 DATE 26 Discount Perc 2 NUMBER 27 Discount Date 3 DATE 28 Discount Perc 3 NUMBER 29 Pre Acc Code B STRING 30 Pre Acc Code C STRING 31 Pre Acc Code D STRING 32 Pre Acc Code E STRING 33 Pre Acc Code F STRING 34 Pre Acc Code G STRING 35 Pre Acc Code H STRING 36 Pre Acc Code I STRING 37 Pre Acc Code J STRING 38 Supplier Order No STRING 39 Our Reference STRING 40 Your Reference STRING 41 Delivery Terms Desc STRING 42 Ship Via Desc STRING 43 Forward Agent STRING 44 Label Note STRING 45 Ncf Reference STRING 46 Pre Project Activity Id STRING 47 Discount curramount 1 NUMBER 48 Discount domamount 1 NUMBER 49 Discount curramount 2 NUMBER 50 Discount domamount 2 NUMBER 51 Discount curramount 3 NUMBER 52 Discount domamount 3 NUMBER 53 Pay Term Base Date DATE 54 ---------------------------------------------------------------------------------- Description: Line Type;Identity;Invoice No;Transaction Date;Invoice Type;Invoice Date;Arrival Date;Due Date;Payment Term Id;Currency;Curr Rate;Auth Id;Voucher Type;Voucher No;Notes;Plan Payment Date;Div Factor;Prelim Code;National Bank Code;Creators Reference;PO Reference;Series Reference;Number Reference;Discount Date 1;Discount Perc 1;Discount Date 2;Discount Perc 2;Discount Date 3;Discount Perc 3;Pre Acc Code B;Pre Acc Code C;Pre Acc Code D;Pre Acc Code E;Pre Acc Code F;Pre Acc Code G;Pre Acc Code H;Pre Acc Code I;Pre Acc Code J;Supplier Order No;Our Reference;Your Reference;Delivery Terms Desc;Ship Via Desc;Forward Agent;Label Note;Ncf Reference;Pre Project Activity Id;Discount curramount 1;Discount domamount 1;Discount curramount 2;Discount domamount 2;Discount curramount 3;Discount domamount 3;Pay Term Base Date; Example: H;B;C;2003-11-13;D;2003-11-13;2003-11-13;2003-11-13;E;F;1;G;H;1;I;2003-11-13;1;J;K;L;M;N;O;2003-11-13;1;2003-11-13;1;2003-11-13;1;P;Q;R;S;T;U;V;W;X;Y;Z;a;a;a;a;a;a;a;1;1;1;1;1;1;2003-11-13; ---------------------------------------------------------------------------------- Record Type : I Supplier Invoice Item ---------------------------------------------------------------------------------- Column Desc Type Column No ---------------------------------------------------------------------------------- Line Type STRING 1 Identity STRING 2 Invoice No STRING 3 Item Id NUMBER 4 Vat Code STRING 5 Net Curr Amount NUMBER 6 Net Dom Amount NUMBER 7 Vat Curr Amount NUMBER 8 Vat Dom Amount NUMBER 9 Reference STRING 10 Deliv Type Id STRING 11 PO Item Reference STRING 12 Item Pos STRING 13 Pur Part No STRING 14 Pur Part Desc STRING 15 Sup Part No STRING 16 Sup Part Desc STRING 17 Invoiced qty NUMBER 18 Sales UM STRING 19 Sales Unit Price NUMBER 20 Price UM STRING 21 Line Discount NUMBER 22 Order Discount NUMBER 23 ---------------------------------------------------------------------------------- Description: Line Type;Identity;Invoice No;Item Id;Vat Code;Net Curr Amount;Net Dom Amount;Vat Curr Amount;Vat Dom Amount;Reference;Deliv Type Id;PO Item Reference;Item Pos;Pur Part No;Pur Part Desc;Sup Part No;Sup Part Desc;Invoiced qty;Sales UM;Sales Unit Price;Price UM;Line Discount;Order Discount; Example: I;B;C;1;D;1;1;1;1;E;F;G;H;I;J;K;L;1;M;1;N;1;1; ---------------------------------------------------------------------------------- Record Type : N Supplier Invoice Installment ---------------------------------------------------------------------------------- Column Desc Type Column No ---------------------------------------------------------------------------------- Line Type STRING 1 Identity STRING 2 Invoice No STRING 3 Installment Id NUMBER 4 Due Date DATE 5 Amount NUMBER 6 Payment Method STRING 7 Payment Address STRING 8 Vat Distribution STRING 9 Dicount Date 1 DATE 10 Discount Prcentage 1 NUMBER 11 Dicount Date 2 DATE 12 Discount Prcentage 2 NUMBER 13 Dicount Date 3 DATE 14 Discount Prcentage 3 NUMBER 15 ---------------------------------------------------------------------------------- Description: Line Type;Identity;Invoice No;Installment Id;Due Date;Amount;Payment Method;Payment Address;Vat Distribution;Dicount Date 1;Discount Prcentage 1;Dicount Date 2;Discount Prcentage 2;Dicount Date 3;Discount Prcentage 3; Example: N;B;C;1;2003-11-13;1;D;E;F;2003-11-13;1;2003-11-13;1;2003-11-13;1; ---------------------------------------------------------------------------------- Record Type : P Supplier Invoice Posting ---------------------------------------------------------------------------------- Column Desc Type Column No ---------------------------------------------------------------------------------- Line Type STRING 1 Identity STRING 2 Invoice No STRING 3 Iten Id NUMBER 4 Row Id NUMBER 5 Code A STRING 6 Code B STRING 7 Code C STRING 8 Code D STRING 9 Code E STRING 10 Code F STRING 11 Code G STRING 12 Code H STRING 13 Code I STRING 14 Code J STRING 15 Quantity NUMBER 16 Curr Amount NUMBER 17 Dom Amount NUMBER 18 Auto Posting Proc Code STRING 19 Optional Code STRING 20 Voucher Row Text STRING 21 Project Activity Id STRING 22 ---------------------------------------------------------------------------------- Description: Line Type;Identity;Invoice No;Iten Id;Row Id;Code A;Code B;Code C;Code D;Code E;Code F;Code G;Code H;Code I;Code J;Quantity;Curr Amount;Dom Amount;Auto Posting Proc Code;Optional Code;Voucher Row Text;Project Activity Id; Example: P;B;C;1;1;D;E;F;G;H;I;J;K;L;M;1;1;1;N;O;P;Q; ---------------------------------------------------------------------------------- Record Type : T Supplier Invoice Tax ---------------------------------------------------------------------------------- Column Desc Type Column No ---------------------------------------------------------------------------------- Line Type STRING 1 Identity STRING 2 Invoice No STRING 3 Item Id NUMBER 4 Tax Id NUMBER 5 Tax Percentage NUMBER 6 Tax Curr Amount NUMBER 7 Tax Dom Amount NUMBER 8 Fee Code STRING 9 ---------------------------------------------------------------------------------- Description: Line Type;Identity;Invoice No;Item Id;Tax Id;Tax Percentage;Tax Curr Amount;Tax Dom Amount;Fee Code; Example: T;B;C;1;1;1;1;1;D; ----------------------------------------------------------------------------------