Legal Format 28 Line by but12492

VIEWS: 0 PAGES: 17

More Info
									                           Green means LEDES has no corrolary data element to Swiss
                           Digin in its current form
                           Gray denotes logical node breaks in the SwissDigin XML format

                                                                                           Orphan colums denote fields in LEDES with no
                                                                                           obvious corresponding data elements in
                                                                                           SwissDigin



        LEDES 1998B-INTL                     SWISS DIGIN                               Orphan Data Fields from LEDES 1998B-INTL
INVOICE_DATE                            DOCUMENT ISSUE DATE [Header - Generic]        INVOICE_DESCRIPTION
INVOICE_NUMBER                             DOCUMENT NUMBER [Header - Generic]         INVOICE_TOTAL
CLIENT_MATTER_ID                     CONTRACT IDENTIFICATION [Header - Generic]       LINE_ITEM_ADJUSTMENT_AMOUNT
PO_NUMBER                       ORDER NUMBER IN BUYER SYSTEM [Header - Generic]       LINE_ITEM_NUMBER
INVOICE_CURRENCY                         DOCUMENT CURRENCY [Header - Generic]         MATTER_NAME
                                              DOCUMENT TYPE [Header - Generic]        TIMEKEEPER_FIRST_NAME
                                                                                      TIMEKEEPER_LAST_NAME
                                       LEGAL NAME OF COMPANY [Header - Delivery] TIMEKEEPER_NAME
                                                        ADDRESS [Header - Delivery] CLIENT_MATTER_ID
                                                     PLACE / CITY [Header - Delivery]
                                              ZIP / POSTAL CODE [Header - Delivery]
                                                       COUNTRY [Header - Delivery]
                              NAME OF THE ORGANIZATIONAL UNIT [Header - Delivery]
BILLING_START_DATE                   DATE OF START OF SERVICE [Header - Delivery]
LAW_FIRM_MATTER_ID             REFERENCE CODE OF FULFILLMENT [Header - Delivery]
                                DATE OF DELIVERY RESP. DATE OF END OF SERVICE
BILLING_END_DATE                                                  [Header - Delivery]

                                   IDENTIFICATION CODE IN BUYERSYSTEM [Header -
                                                                             Supplier]
LAW_FIRM_ID                          TAX IDENTIFICATION NUMBER [Header - Supplier]
                                       LEGAL NAME OF COMPANY [Header - Supplier]
                                                         ADDRESS [Header - Supplier]
                                                      PLACE / CITY [Header - Supplier]
                                               ZIP / POSTAL CODE [Header - Supplier]
                                                        COUNTRY [Header - Supplier]
                 NAME OF THE ORGANIZATIONAL UNIT [Header - Supplier]
                                CONTACT PERSON [Header - Supplier]

CLIENT_ID           CLIENT NUMBER IN SELLER SYSTEM [Header - Client]
CLIENT_TAX_ID            TAX IDENTIFICATION NUMBER [Header - Client]
                            LEGAL NAME OF COMPANY [Header - Client]
                                              ADDRESS [Header - Client]
                                           PLACE / CITY [Header - Client]
                                   ZIP / POSTAL CODE [Header - Client]
                                             COUNTRY [Header - Client]
                 IDENTIFICATION CODE OF THE ORGANIZATIONAL UNIT
                                                        [Header - Client]
                   NAME OF THE ORGANIZATIONAL UNIT [Header - Client]
                                         IDENTIFICATION OF CONTACT
                           PERSON/UNIT/DEPARTMENT [Header - Client]
                                       ADDITIONAL INFORMATION ON
                           PERSON/UNIT/DEPARTMENT [Header - Client]

                                 PAYMENT TERMS [Header - Payment]
                                PAYMENT PERIOD [Header - Payment]
                                       DUE DATE [Header - Payment]
                                  DISCOUNT RATE [Header - Payment]
                           DUE DATE OF DISCOUNT [Header - Payment]
                     PAYMENT REFERENCE NUMBER [Header - Payment]
                 PAYMENT REFERENCE MEMBERSHIP NUMBER [Header -
                                                          Payment]
                          BANK CLEARING NUMBER [Header - Payment]

                NUMBER OF POSTAL / BANK ACCOUNT [Header - Payment]
                                     IBAN NUMBER [Header - Payment]

                      REFERENCE TO ATTACHMENT [Header - Additional]

                ACCOUNT ASSIGNMENT CATEGORY [Header - Additional]
                       TEXTFIELD FOR COMMENTS [Header - Additional]
                VALUE OF ACCOUNT ASSIGNMENT CATEGORY [Header -
                                                        Additional]
TIMEKEEPER_ID                           ARTICLE NUMBER OF SUPPLIER [Line Item - Article]
LINE_ITEM_NUMBER_OF_UNITS                               UNITS SOLD [Line Item - Article]
                                        DESCRIPTION OF GOODS SUPPLIED OR SERVICE
LINE_ITEM_DESCRIPTION                                    RENDERED [Line Item - Article]
LINE_ITEM_UNIT_COST                                      PRICE UNIT [Line Item - Article]
                                           ARTICLE NUMBER OF BUYER [Line Item - Article]
TIMEKEEPER_CLASSIFICATION                 STANDARD ARTICLE NUMBER [Line Item - Article]
                                              UNIT OF MEASUREMENT [Line Item - Article]

EXP/FEE/TAX/INV_ADJ_TYPE                          LINE ITEM TYPE [Line Item - Reference]
                                        DATE OF START OF SERVICE [Line Item - Delivery]
                                DATE OF DELIVERY RESP. DATE OF END OF SERVICE [Line
LINE_ITEM_DATE                                                            Item - Delivery]

                                  REFERENCE CODE OF FULFILLMENT [Line Item - Delivery]

                                       CHARGE / ALLOWANCE TOTAL AMOUNT [Line Item -
                                                                          Charges]
LINE_ITEM_TASK_CODE [and]
LINE_ITEM_ACTIVITY_CODE, [or]    CHARGE / ALLOWANCE CODE [Line Item - Charges] [*Note -
LINE_ITEM_EXPENSE_CODE                               Used for Task and Expense codes]
                                 CHARGE / ALLOWANCE CODE [Line Item - Charges] [*Note -
                                                     Used for Task and Expense codes]

                                 CHARGE / ALLOWANCE DESCRIPTION [Line Item - Charges]
                                  CHARGE / ALLOWANCE CALCULATION BASIS [Line Item -
                                                                              Charges]
                                         CHARGE / ALLOWANCE UNIT [Line Item - Charges]
                                CHARGE / ALLOWANCE UNIT OF MEASUREMENT [Line Item -
                                                                              Charges]

                                                      TAXABLE AMOUNT [Line Item - Price]
                                                   UNIT PRICE EXCL. VAT [Line Item - Price]
                                                   UNIT PRICE INCL. VAT [Line Item - Price]
                                                 VAT PERCENTAGE RATE [Line Item - Price]
                                                  VAT AMOUNT PAYABLE [Line Item - Price]
LINE_ITEM_TOTAL                  TOTAL AMOUNT INCL. VAT [Line Item - Price]


                    ACCOUNT ASSIGNMENT CATEGORY [Line Item - Additional]
                    VALUE OF ACCOUNT ASSIGNMENT CATEGORY [Line Item -
                                                               Additional]
                         REFERENCE TO ATTACHMENT [Line Item - Additional]
                           TEXTFIELD FOR COMMENTS [Line Item - Additional]
                           ORDER LINE ITEM NUMBER OF BUYER [Line Item -
                                                              Reference]

                         TOTAL AMOUNT OF INVOICE INCL. VAT [Footer - Total
INVOICE_NET_TOTAL                                               Amounts]
INVOICE_TOTA -          TOTAL AMOUNT OF INVOICE EXCL. VAT [Footer - Total
INVOICE_TAX_TOTAL                                               Amounts]
                            ROUNDING DIFFERENCE [Footer - Total Amounts]

                                    VAT PERCENTAGE RATE [Footer - VAT]
                                         TAXABLE AMOUNT [Footer - VAT]
                      REFERENCE IN CASE OF VAT EXEMPTION [Footer - VAT]
                                     TAX AMOUNT PAYABLE [Footer - VAT]
                         LEDES 2000
invoice.date [and/or] invoice.inv_date
invoice.inv_id
matter.sequence
matter.cl_matter_var_1 (PO Number)
invoice.inv_currency



firm.lf_name
firm.lf_remit_address.address_1
firm.lf_remit_address.city [and]
firm.lf_remit_address.state_province
firm.lf_remit_address.zip_postal_code
firm.lf_remit_address.country

invoice.inv_start_date
matter.cl_matter_id

invoice.inv_end_date



firm.lf_id

firm.lf_tax_id
firm.lf_name
firm.lf_address.address_1
firm.lf_address.city [and] firm.lf_address.state_province
firm.lf_address.zip_postal_code
firm.lf_address.country

firm.lf_billing_contact_fname [and]
firm.lf_billing_contact_lname

client.cl_lf_id
client.cl_tax_id
client.cl_name
client.cl_address.address_1
client.cl_address.city
client.cl_address.state_province [and]
client.cl_address.zip_postal_code
client.cl_address.country




client.cl_contact_fname [and] client.cl_contact_lname

client.cl_email


invoice.inv_payment_terms

invoice.inv_due_date
invoice.inv_generic_discount
invoice.inv_desc


  NOTE THAT CORRELATION OF EXPENSE FIELDS TO
SWISSDIGIN FIELDS SHOW HERE APPLIES THE SAME TO
ALL FEE LINE ITEM DATA FIELDS SHOW IN BLACK BOX IN
                     COLUMN G
tksum.tk_id
tksum.tk_hours



tksum.tk_rate

tksum.tk_level



expense.charge_type
expense.date

expense.date




expense.acca_expense

expense.acca_expense




expense.base_amount

expense.rate
expense.tax_rate
expense.tax_on_charge
expense.total_amount




invoice.inv_total_net_due
               SWISS DIGIN                                Orphan Client Data from L2K
          DOCUMENT ISSUE DATE [Header - Generic]    client.app
             DOCUMENT NUMBER [Header - Generic]     client.cl_address.address_2
       CONTRACT IDENTIFICATION [Header - Generic]   client.cl_address.address_3
  ORDER NUMBER IN BUYER SYSTEM [Header - Generic]   client.cl_address.fax
           DOCUMENT CURRENCY [Header - Generic]     client.cl_address.phone
                DOCUMENT TYPE [Header - Generic]    client.cl_id
                                                    client.date
          LEGAL NAME OF COMPANY [Header - Delivery] client.ext_name
                        ADDRESS [Header - Delivery] client.ext_value

                       PLACE / CITY [Header - Delivery] client.sequence
                ZIP / POSTAL CODE [Header - Delivery] client.vendor
                         COUNTRY [Header - Delivery]
NAME OF THE ORGANIZATIONAL UNIT [Header - Delivery]
       DATE OF START OF SERVICE [Header - Delivery]
 REFERENCE CODE OF FULFILLMENT [Header - Delivery]
  DATE OF DELIVERY RESP. DATE OF END OF SERVICE
                                    [Header - Delivery]

    IDENTIFICATION CODE IN BUYERSYSTEM [Header -
                                              Supplier]
      TAX IDENTIFICATION NUMBER [Header - Supplier]
         LEGAL NAME OF COMPANY [Header - Supplier]
                          ADDRESS [Header - Supplier]
                       PLACE / CITY [Header - Supplier]
                ZIP / POSTAL CODE [Header - Supplier]
                         COUNTRY [Header - Supplier]
NAME OF THE ORGANIZATIONAL UNIT [Header - Supplier]

                  CONTACT PERSON [Header - Supplier]

   CLIENT NUMBER IN SELLER SYSTEM [Header - Client]
        TAX IDENTIFICATION NUMBER [Header - Client]
           LEGAL NAME OF COMPANY [Header - Client]
                          ADDRESS [Header - Client]
                       PLACE / CITY [Header - Client]

                 ZIP / POSTAL CODE [Header - Client]
                           COUNTRY [Header - Client]
IDENTIFICATION CODE OF THE ORGANIZATIONAL UNIT
                                    [Header - Client]
  NAME OF THE ORGANIZATIONAL UNIT [Header - Client]
                       IDENTIFICATION OF CONTACT
          PERSON/UNIT/DEPARTMENT [Header - Client]
                     ADDITIONAL INFORMATION ON
          PERSON/UNIT/DEPARTMENT [Header - Client]

                   PAYMENT TERMS [Header - Payment]
                   PAYMENT PERIOD [Header - Payment]
                         DUE DATE [Header - Payment]
                    DISCOUNT RATE [Header - Payment]
            DUE DATE OF DISCOUNT [Header - Payment]
      PAYMENT REFERENCE NUMBER [Header - Payment]
  PAYMENT REFERENCE MEMBERSHIP NUMBER [Header -
                                           Payment]
           BANK CLEARING NUMBER [Header - Payment]

 NUMBER OF POSTAL / BANK ACCOUNT [Header - Payment]
                      IBAN NUMBER [Header - Payment]

       REFERENCE TO ATTACHMENT [Header - Additional]
  ACCOUNT ASSIGNMENT CATEGORY [Header - Additional]
         TEXTFIELD FOR COMMENTS [Header - Additional]
  VALUE OF ACCOUNT ASSIGNMENT CATEGORY [Header -
                                          Additional]




        ARTICLE NUMBER OF SUPPLIER [Line Item - Article]
                        UNITS SOLD [Line Item - Article]
        DESCRIPTION OF GOODS SUPPLIED OR SERVICE
                         RENDERED [Line Item - Article]
                         PRICE UNIT [Line Item - Article]
           ARTICLE NUMBER OF BUYER [Line Item - Article]
          STANDARD ARTICLE NUMBER [Line Item - Article]
              UNIT OF MEASUREMENT [Line Item - Article]

                  LINE ITEM TYPE [Line Item - Reference]
        DATE OF START OF SERVICE [Line Item - Delivery]
DATE OF DELIVERY RESP. DATE OF END OF SERVICE [Line
                                          Item - Delivery]

  REFERENCE CODE OF FULFILLMENT [Line Item - Delivery]

     CHARGE / ALLOWANCE TOTAL AMOUNT [Line Item -
                                             Charges]
 CHARGE / ALLOWANCE CODE [Line Item - Charges] [*Note -
                     Used for Task and Expense codes]
 CHARGE / ALLOWANCE CODE [Line Item - Charges] [*Note -
                     Used for Task and Expense codes]

 CHARGE / ALLOWANCE DESCRIPTION [Line Item - Charges]
  CHARGE / ALLOWANCE CALCULATION BASIS [Line Item -
                                              Charges]
         CHARGE / ALLOWANCE UNIT [Line Item - Charges]
CHARGE / ALLOWANCE UNIT OF MEASUREMENT [Line Item -
                                              Charges]

                      TAXABLE AMOUNT [Line Item - Price]
                   UNIT PRICE EXCL. VAT [Line Item - Price]
                   UNIT PRICE INCL. VAT [Line Item - Price]
                 VAT PERCENTAGE RATE [Line Item - Price]
               VAT AMOUNT PAYABLE [Line Item - Price]
             TOTAL AMOUNT INCL. VAT [Line Item - Price]


ACCOUNT ASSIGNMENT CATEGORY [Line Item - Additional]
VALUE OF ACCOUNT ASSIGNMENT CATEGORY [Line Item -
                                           Additional]
     REFERENCE TO ATTACHMENT [Line Item - Additional]
       TEXTFIELD FOR COMMENTS [Line Item - Additional]
       ORDER LINE ITEM NUMBER OF BUYER [Line Item -
                                          Reference]

     TOTAL AMOUNT OF INVOICE INCL. VAT [Footer - Total
                                            Amounts]
    TOTAL AMOUNT OF INVOICE EXCL. VAT [Footer - Total
                                            Amounts]
        ROUNDING DIFFERENCE [Footer - Total Amounts]

                VAT PERCENTAGE RATE [Footer - VAT]
                     TAXABLE AMOUNT [Footer - VAT]
  REFERENCE IN CASE OF VAT EXEMPTION [Footer - VAT]
                 TAX AMOUNT PAYABLE [Footer - VAT]
    Orphan LF Data From L2K        Orphan Invoice Data From L2K
firm.app                          invoice.app
firm.app_version                  invoice.ext_name
firm.date                         invoice.ext_value
firm.ext_name
firm.ext_value                    invoice.sequence
firm.lf_address.address_2         invoice.vendor
firm.lf_address.address_3
firm.lf_address.address_3
firm.lf_address.fax
firm.lf_address.phone
firm.lf_billing_contact_email
firm.lf_billing_contact_fax
firm.lf_billing_contact_id
firm.lf_billing_contact_phone


firm.lf_remit_address.address_2

firm.lf_remit_address.fax

firm.lf_remit_address.phone

firm.sequence
firm.source_app
firm.vendor
    Orphan Matter Data From L2K     Orphan Fee/Expense Data From L2K
matter.app                         expense.app
matter.cl_contact_email
matter.cl_contact_fname            expense.cl_code_1
matter.cl_contact_id               expense.cl_code_2
matter.cl_contact_lname            expense.discount_amount
matter.cl_contact_phone            expense.discount_percent
matter.sequence                    expense.discount_type
matter.cl_matter_var_2             expense.expense_charge_date
matter.date                        expense.ext_name
matter.eft_agreement_number        expense.ext_value
matter.ext_name                    expense.sequence
matter.ext_value                   expense.tk_id
matter.lf_contact_email            expense.vendor
matter.lf_contact_id               fee.acca_activity
matter.lf_contact_phone            fee.app

matter.lf_managing_contact_fname   fee.base_amount

matter.lf_managing_contact_lname   fee.charge_date

matter.lf_matter_id                fee.charge_type

matter.matter_adj_on_exp           fee.cl_code_1
matter.matter_adj_on_fees          fee.cl_code_2
matter.matter_billing_type         fee.date
matter.matter_desc                 fee.discount_amount
matter.matter_final_bill           fee.discount_percent
matter.matter_name                 fee.discount_type
matter.matter_net_exp              fee.ext_name
matter.matter_net_fees             fee.ext_value
matter.matter_perc_shar_exp        fee.rate
matter.matter_perc_shar_fees       fee.sequence
matter.matter_tax_on_exp           fee.tax_on_charge
matter.matter_tax_on_fees          fee.tax_rate
matter.matter_total_detail_exp     fee.tk_id
matter.matter_total_detail_fees    fee.total_amount
matter.matter_total_due            fee.vendor
matter.vendor
   Orphan Timekeeper Data From L2K
tksum.app
tksum.date
tksum.ext_name
tksum.ext_value
tksum.sequence
tksum.tk_cost
tksum.vendor
tksum.tk_fname [and] tksum.tk_lname

								
To top